Results 1 to 3 of 3

Macro to loop through and move data to new tabs

Threaded View

tso6359 Macro to loop through and... 03-03-2011, 11:00 PM
watersev Re: Macro to loop through and... 03-04-2011, 06:15 AM
tso6359 Re: Macro to loop through and... 03-05-2011, 03:05 PM
  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    Madison, Wisconsin
    MS-Off Ver
    Excel 2003
    Posts
    4

    Macro to loop through and move data to new tabs

    Each week I receive an excel report where I need to separate the data into new tabs.

    The first column contains, for example 700 lines with the same repeating name and then 200 lines of the next repeating name and then 300 lines of the next repeating name etc. Each week the 700, 200 and 300 numbers will vary. It may be 720,195 315 etc.

    I would like to have a macro that will read through each of the repeating names and put them each into a new (separate) tab on the workbook. If the numbers did not vary I could just record a macro to cut and paste but I don't know how to deal with the varying number of rows.

    I've attached a small example of a spreadsheet.

    Thank you
    Attached Files Attached Files
    Last edited by tso6359; 03-05-2011 at 03:10 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1