Search:

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

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    14
    Views
    308

    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.
  2. Replies
    14
    Views
    308

    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.
  3. Replies
    9
    Views
    120

    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.
  4. Replies
    14
    Views
    308

    I think the attached does as desired

    I think the attached does as desired
  5. Replies
    8
    Views
    188

    Post a file

    Post a file
  6. Replies
    14
    Views
    308

    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.
  7. Replies
    8
    Views
    188

    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.
  8. Replies
    14
    Views
    308

    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
  9. Replies
    14
    Views
    308

    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...
  10. Glad to help

    Glad to help
  11. Replies
    5
    Views
    201

    try Erase RangeArray2(j)

    try
    Erase RangeArray2(j)
  12. Replies
    5
    Views
    201

    try .CurrentRegion.Clear

    try

    .CurrentRegion.Clear
  13. 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...
  14. This was to show you how to get the workbook. You...

    This was to show you how to get the workbook. You then supply the rest. Search the archives as there are examples of exactly what you want.
  15. Since I can't figure this out I have decided to...

    Since I can't figure this out I have decided to delete the account in WLM that goes to my gmail acct. Am I asking the obvious or do I NOT lose my emails if I cancel the acct>add it again>import NEW...
  16. Try adapting this to your needs by looping ...

    Try adapting this to your needs by looping
    Sub Iterate_Files()
    Dim ctr As Integer
    ctr = 1
    Path = "C:\Windows\ " ' Path should always contain a '\' at end
    File =...
  17. Replies
    3
    Views
    248

    Here is one I have used to saveas .XLS Sub...

    Here is one I have used to saveas .XLS
    Sub SaveAsXLS()
    FNAME = ActiveWorkbook.Name
    FNAME = Left(FNAME, Len(FNAME) - 4)
    ActiveWorkbook.SaveAs Filename:="C:\PERSONAL\" & FNAME & ".xls", _
    ...
  18. Would have helped to, at least, show us your...

    Would have helped to, at least, show us your effort(s).
    Let's see if we have the logic
    I want to look at the date in col A and
    if it shows up in col E, then
    if then the amount in col b shows...
  19. http://software-solutions-online.com/2014/03/11/ex...

    http://software-solutions-online.com/2014/03/11/excel-vba-open-file-dialog/
  20. Ditto from Texas

    Ditto from Texas
  21. Yes, NO help I am at my wits end. Don't want to...

    Yes, NO help
    I am at my wits end. Don't want to lose my email.
  22. I found that and it is a very OLD file. Anyway,...

    I found that and it is a very OLD file. Anyway, how would I import from that if desired?
    However, the problem is not that I can't import and add more contacts. It is that I cannot delete the dups....
  23. WLM can NOT delete multple duplicate contacts

    The title says it all. I have a contact

    contact email addy phone company
    contact
    contact

    I can delete the good one but NOT the others. ??????????????????
  24. You did not include your formula

    You did not include your formula
  25. i figured out the 1st part. Email addys all had 2...

    i figured out the 1st part. Email addys all had 2 spaces at the end. Removed in Excel and all is OK.

    I would still like to know if there is a way to do the rest?

    Also, I want these to sync...
Results 1 to 25 of 151
Page 1 of 7 1 2 3 4