Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    4
    Views
    50

    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...
  2. Check out this thread ...

    Check out this thread

    http://windowssecrets.com/forums/showthread.php/158474-Excel-2010-copying-and-pasting-to-an-existing-graph
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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

    ...
  8. Replies
    20
    Views
    721

    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
  9. 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
  10. 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...
  11. 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...
  12. Replies
    3
    Views
    64

    dcarroll, As an alternative:...

    dcarroll,

    As an alternative: =SUMIF(range,criteria,sum_range)

    Cell B1 =SUMIF(Sheet2!$A$1:$A$30,Sheet1!A1,Sheet2!$C$1:$C$30) and drag down

    39115

    39116
  13. You are using Option Explicit. Please add "Dim I...

    You are using Option Explicit. Please add "Dim I as Integer" near the top in the CMDAdd_Click() routine.

    39112
  14. Howard, You can add a spinbutton with a text...

    Howard,

    You can add a spinbutton with a text box to control the number of times the entry is copied to the sheet. Below is the changes to your Userform code that you will need to make:

    39108
    ...
  15. Replies
    20
    Views
    721

    Scubajay, Here is the code that should do what...

    Scubajay,

    Here is the code that should do what you want. Clicking on the Transfer button will open the destination workbook and transfer each row from sheets 2 through 4 in the source file to...
  16. Replies
    3
    Views
    75

    Or place in the cell =if(B5="","",B5) Read as...

    Or place in the cell
    =if(B5="","",B5)
    Read as "if B5 is blank then value is blank else the value is the same as B5"
  17. Replies
    2
    Views
    64

    Gvandale, Another approach is placing this...

    Gvandale,

    Another approach is placing this code in the Workbook_open event routine of ThisWorkbook module where A1 is the cell with the incrementing value:



    Private Sub Workbook_Open()
    With...
  18. Replies
    6
    Views
    514

    Mac, Let's say your columns are A, B, and C...

    Mac,

    Let's say your columns are A, B, and C while the rows are from 1 to 89 assuming no header. Following cmptrgy's thought, if you have additional data elsewhere on the sheet but do not want to...
  19. Replies
    2
    Views
    93

    Howard, See if this meets your needs: ...

    Howard,

    See if this meets your needs:



    Sub Clear_Data()
    On Error Resume Next
    '--------------------------------------------------------
    'DECLARE AND SET VARIABLES
  20. Grant, See if this solves your problem: ...

    Grant,

    See if this solves your problem:




    Sub TShirt_Summary()
    Application.ScreenUpdating = False
    '-----------------------------------------------------------
  21. Replies
    6
    Views
    348

    In an answer to the original question, greater...

    In an answer to the original question, greater than 92 quadrillion dollars.
  22. Replies
    5
    Views
    150

    Confused as to whether the specific will "change"...

    Confused as to whether the specific will "change" as to by location or by text.
  23. Kwelti, I have let the program function...

    Kwelti,

    I have let the program function overnight (minimized) and all day so far (minimized and Maximized). I have received the hourly updates as expected. I also ran simultaneous spreadsheets...
  24. Kwelti, Seeing if I can reproduce the same...

    Kwelti,

    Seeing if I can reproduce the same results. Will get back to you soon.

    Maud
  25. Replies
    5
    Views
    150

    RG, If I am not mistaken, I believe the OP is...

    RG,

    If I am not mistaken, I believe the OP is indicating that the specific can change each time, meaning that the specific may not always be an "R". This would require editing the conditions. ...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4