Search:

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

Search: Search took 0.00 seconds.

  1. Transitive Property data Categorizatio nquestion

    I have a list of 2000+ book titles. In our database, we track the previous version of the book. But I want to create a table which shows, for a given title line, all versions of the book. Below is an...
  2. Replies
    0
    Views
    138

    Search for text to group into categories

    Hi all,

    Here's my problem:

    I have a list of 1200 sub-accounts, and I want to group them into parent accounts Based on similar text with the sub-account name. For example, one vendor may have 30...
  3. Replies
    1
    Views
    280

    Re: Copy files to a new folder using VBA

    Any ideas?? :confused:
  4. Replies
    1
    Views
    280

    Copy files to a new folder using VBA

    Hi all,

    I have a VBA question for you all which would be hugely helpful if i could get working:

    I have 2 columns: Column A has a new folder name that I'd like created
    Column B has the first 6...
  5. Re: VBA macro to Collapse/Expand all grouped rows/columns

    Thank you!! This is so helpful.
  6. VBA macro to Collapse/Expand all grouped rows/columns

    Hi all,

    I'd like to be able to run a macro which would collapse or expand all grouped rows and columns for all selected worksheets. When I say collapse or expand, i don't need any selection dialog...
  7. Replies
    3
    Views
    267

    Re: Group rows on selected sheets

    Awesome. Thanks much.
  8. Replies
    3
    Views
    267

    Group rows on selected sheets

    Hi all,

    I'm trying to find a macro to do the following:

    I select (highlight) a varying number of sheets, and highlight a varying number of rows (for example, select sheets 1 - 10, rows 1-10)...
  9. Replies
    1
    Views
    280

    Group rows on all active sheets

    Hi all,

    Excel won't let you group rows on multiple active sheets in the GUI.

    Can someone provide code to group selected rows/columns so that all selected sheets will group together?

    Thanks!
  10. Copy rows of data on multiple sheets to one column

    Hi,

    Question for you all:

    I have a workbook with a varying number of sheets, with a varying number of data in column A in each sheet. I would like a macro which will take all the data from each...
  11. Replies
    2
    Views
    280

    Re: VBA Help: name existing sheets from list

    so simple. awesome. thank you!!!
  12. Replies
    2
    Views
    280

    VBA Help: name existing sheets from list

    Hi all,

    Wondering if I can get some help, shouldn't be too much code but i'm new to VBA.

    I have a list of varying length in Sheet1 in column A which I want to be the sheet names of already...
  13. Replies
    8
    Views
    5,947

    Re: VBA: when to use :=

    great, thanks for the response. much clearer now.
  14. Replies
    8
    Views
    5,947

    Re: VBA: when to use :=

    awesome. thanks for the very clear analogy.
  15. Replies
    8
    Views
    5,947

    Re: VBA: when to use :=

    I saw it in this video by Mr. Excel
    http://www.youtube.com/user/bjele123#p/c/76C979CEFD1A4B30/7/cGsbbjt5pIM

    the line is:

    worksheets.add after:=worksheets(worksheets.count)

    this line adds a...
  16. Replies
    8
    Views
    5,947

    VBA: when to use :=

    When do you use the := and what does it mean?

    Also, if you have option explicit on and you want to dimension the following

    dim cell as ___

    for something like

    for each cell in selection
  17. Re: Calculating a percentage of bounced emails per company

    Okay, so I used the pivot table to summarize the number of T/F for each company, and a grand total for the total number of contacts for each company.

    My question now is, how can i do math on the...
  18. Re: Calculating a percentage of bounced emails per company

    ah.....pivot table. i've never used one to actually do anything...just watched a video on them a little while back. okay, that should work though. a lot easier probably. thanks!
  19. Re: Calculating a percentage of bounced emails per company

    sorry...i titled this question wrong...

    the way i obtained the True/False was by bounced emails...but that's not really important for my question, so just assume that the T/F are just hard coded...
  20. Calculating a percentage of bounced emails per company

    Hello everyone,

    I have a question...it seems like it might be kinda tricky.


    Here are my field names:

    LastName, FirstName, Company, True/False
  21. Counting Duplicates in a list...how does this formula work???

    This formula will count duplicates in a list. If you have a list that says:

    eggs
    eggs
    beef
    beef
    beef
    chicken

    the formula will return:
Results 1 to 21 of 21