Search:

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

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. I did say OR but since you have the data why not...

    I did say OR but since you have the data why not try a macro using advanced filter for unique.
  2. Why not just have a cell above the table where...

    Why not just have a cell above the table where Maud is entered or selected from a drop down and another to enter philly and then a subtotal(104 for the range) in the next cell. Have a worksheet...
  3. Replies
    14
    Views
    474

    Post your final file that works as desired. The...

    Post your final file that works as desired. The macro, as written, assumes only the getdata sheet and the ONLY the monthly sheets to the right. Just use the getdata sheet and the code module which...
  4. Replies
    14
    Views
    474

    Somehow I was under the impression that you did...

    Somehow I was under the impression that you did NOT want data where the ref column was blank???
    I commented out the line to clear that row if the ref column is blank.
    Is this what you need.
    See att
  5. Replies
    14
    Views
    474

    Just a minor tweak required to pick up Rows with...

    Just a minor tweak required to pick up Rows with a 'blank' Ref. field (Col. D) eg Mar14 R33-35, 39, 41-42.
    Not quite sure what you mean here. Send me sample illustration.

    Total is NOT a problem...
  6. Replies
    14
    Views
    474

    As OP said needs to work in lower version. See...

    As OP said needs to work in lower version. See attached assumes destination sheet is always to the left and montly sheets ONLY are to the right.
  7. Replies
    22
    Views
    833

    Since OP never came back, you also wasted your...

    Since OP never came back, you also wasted your time. Frustrating, isn't it. BTW, I don't thnk yours did as OP desired either and I'm not sure that OP would ever be satisfied. My comment about freebie...
  8. Replies
    20
    Views
    664

    The only problem I see with this is that it will...

    The only problem I see with this is that it will fire each time you do a print preview so you may want to use a checkbox approach instead.
  9. Replies
    20
    Views
    664

    Put is a checkbox and if checked apply the macro,...

    Put is a checkbox and if checked apply the macro, if not, don't
  10. Replies
    22
    Views
    833

    I do NOT need or desire anyone to apologize for...

    I do NOT need or desire anyone to apologize for me ever. I have been doing this a long time and grow tired of posters who can't seem to know what they want and when you do an entire project for them...
  11. 'Place all lines below into the THISWORKBOOK...

    'Place all lines below into the THISWORKBOOK module of your file. Change a1 to the cell with your clients name
    '=======
    Option Explicit
    Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Dim...
  12. Replies
    22
    Views
    833

    You should have mentioned all of this in your...

    You should have mentioned all of this in your ORIGINAL post. It is frustrating to do a project and then be told it works but is not what is needed. I see no reason to continue with this as a freebie.
  13. Replies
    22
    Views
    833

    OK. See attached. BTW, You don't say how the...

    OK. See attached.
    BTW, You don't say how the sheets are populated. I would think that could also be automated in the ONE click.
  14. Replies
    22
    Views
    833

    OK. Do you want it as in YOUR example or in MINE...

    OK. Do you want it as in YOUR example or in MINE without the blanks.
  15. Replies
    20
    Views
    664

    Is this ROW shading? If so, how did it get there?...

    Is this ROW shading? If so, how did it get there? If conditional formatting just record a macro applying the CF and removing the CF. Now, change it to remove the CF>print>replace CF.
  16. Replies
    22
    Views
    833

    I think the attached does as desired

    I think the attached does as desired
  17. Replies
    8
    Views
    399

    Post a file

    Post a file
  18. Replies
    22
    Views
    833

    As requested, post a before/after example showing...

    As requested, post a before/after example showing both sheets before and one after sheet in the same fiie.
  19. Replies
    8
    Views
    399

    I strongly suggest ONE worksheet with all and an...

    I strongly suggest ONE worksheet with all and an extra column to identify the "sheet" Post file.
  20. Replies
    22
    Views
    833

    OK. I see that now but hesitate to go any further...

    OK. I see that now but hesitate to go any further if the OP is NOT coming back. We really need to see an AFTER example on sheet 3
  21. Replies
    22
    Views
    833

    This code (insert a REGULAR module and put it...

    This code (insert a REGULAR module and put it there) should do what you want for sheet names and culling columns/rows. However, you don't say where you want these subtotals, sheet 2 doesn't have...
  22. Glad to help

    Glad to help
  23. Replies
    5
    Views
    224

    try Erase RangeArray2(j)

    try
    Erase RangeArray2(j)
  24. Replies
    5
    Views
    224

    try .CurrentRegion.Clear

    try

    .CurrentRegion.Clear
  25. Since you didn't mention version I am assuming...

    Since you didn't mention version I am assuming 2003 or earlier so weeknum won't work in sumproduct but
    With a helper column in col i
    =weeknum(e6)
    and copied down you can use...
Results 1 to 25 of 163
Page 1 of 7 1 2 3 4