Search:

Type: Posts; User: Maudibe; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. The groupings on your sheets are now apparent. ...

    The groupings on your sheets are now apparent. This is very doable. Does the consolidation sheet start out totally blank and both the descriptions and the values are written to it? If so, is there...
  2. Replies
    2
    Views
    28

    XP, How about this subroutine: Public...

    XP,

    How about this subroutine:



    Public Sub SheetName()
    Worksheets("Sheet5").Range("A1") = ActiveSheet.Name
    End Sub
  3. Howard, With multiple descriptions on the same...

    Howard,

    With multiple descriptions on the same sheet, there must be a way to distinguish them from each other. For example, in BR2, if there was a related index, part, or job number in column A...
  4. Thread: US Citizenship

    by Maudibe
    Replies
    11
    Views
    169

    How does GB handle their citizenship in a similar...

    How does GB handle their citizenship in a similar scenario?
  5. :cool:

    :cool:
  6. Howard, Here is some code that will find...

    Howard,

    Here is some code that will find matching description on sheets BR1 and BR2 then copy the added values in the columns as you describe to the matching description on the Consolidation...
  7. While my first post lets you choose which part to...

    While my first post lets you choose which part to strikethrough, these codes will do it automatically based on the values of other cells.

    Here is the code if "Australian†" or "foreign†" is...
  8. almirena, I am going to take a wild stab at...

    almirena,

    I am going to take a wild stab at what I think you are trying to do. Here is some code that will do the following:

    If you click on a cell with the text "Australian† or foreign†...
  9. Thread: US Citizenship

    by Maudibe
    Replies
    11
    Views
    169

    Brilliant!!! KW, you are a very intelligent man....

    Brilliant!!! KW, you are a very intelligent man. I had absolutely no idea until someone told me the answer which I verified on line.
  10. Luciat, To the code in which post are you...

    Luciat,

    To the code in which post are you referring to?
  11. Mike, I revised your file with code that is...

    Mike,

    I revised your file with code that is initiated from a button placed on the "Reporting Parameters" page. Once you enter in your start and end dates, click the button and your charts will be...
  12. Thread: US Citizenship

    by Maudibe
    Replies
    11
    Views
    169

    Nope, not necessarily Amish although they are...

    Nope, not necessarily Amish although they are citizens...good thought. Parents don't have to be diplomats. Oh KW, My cousin says your check out fine. But no one is yet close.
  13. Thread: US Citizenship

    by Maudibe
    Replies
    11
    Views
    169

    Didn't know that there was a Pennsylvania outside...

    Didn't know that there was a Pennsylvania outside the US...nice! So that is one answer but if we were talking about Pennsylvania in the US what would be the solution?
  14. Thread: US Citizenship

    by Maudibe
    Replies
    11
    Views
    169

    US Citizenship

    How is it that a person born in Pennsylvania, whose parents were both born in Pennsylvania, is not born a U.S. Citizen?
  15. Replies
    6
    Views
    111

    First, you have to amend your formula from ...

    First, you have to amend your formula from
    =COUNTIF($B$2:B826638,B2) to =COUNTIF($B$2:$B$826638,B2)
    or when you copy down you will run out of resources because the upper limit of the range grows...
  16. Check out this thread ...

    Check out this thread

    http://windowssecrets.com/forums/showthread.php/158474-Excel-2010-copying-and-pasting-to-an-existing-graph
  17. Then is there a middle ground that will list them...

    Then is there a middle ground that will list them all?

    39148



    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim rngCell As Range
    Dim RngSearch As Range
    Dim...
  18. Alan, I changed the criteria in cell a1 to B1...

    Alan,

    I changed the criteria in cell a1 to B1 but didn't change it in the formula that I listed. Please note the formula in the formula bar in the picture

    I made the update in my original...
  19. Alan, You could also paste the following...

    Alan,

    You could also paste the following formula where you want the row:column listed. Here, the formula is placed in B2 and matches the value in B1.
    Cell B2...
  20. Lucia, If you can't get the above code to...

    Lucia,

    If you can't get the above code to work, you can incorporate the following code into yours. It will cycle through the sheets, filter each sheet according to your parameters, and copy each...
  21. Lucia, In the line ...

    Lucia,

    In the line

    wTarget("MKT").Cells(lMaxTargetRow + 1, 1)

    wTarget is the active sheet and cannot accept a name parameter. Try changing the line to

    ...
  22. Replies
    20
    Views
    762

    Scubajay, I think this should do the...

    Scubajay,

    I think this should do the trick.....Heineken!



    Sub Transfer()
    On Error Resume Next
    '---------------------------------------------
    'DECLARE OBJECTS/VARIABLES
  23. Howard, Add this code to your userform's...

    Howard,

    Add this code to your userform's module



    Private Sub Txtcost_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    Txtcost.Value = Format(Txtcost.Value, "##.00")
    End Sub
  24. Balla, If I am understanding you correctly,...

    Balla,

    If I am understanding you correctly, from an open workbook you want to run a macro that will cycle though a folder and successively open spreadsheet files that have at least 3 worksheets...
  25. As Bender states, locking a cell has no effect...

    As Bender states, locking a cell has no effect unless you protect the sheet. To avoid the process of formatting the cells as protected one by one, while holding down the ctrl key, click on each cell...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4