+ Reply to Thread
Results 1 to 1 of 1

Move data based on their headers to mater

  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Move data based on their headers to mater

    Looking for a way to move data from many worksheets to a master worksheet within a workbook based on the headers. So if the same headers are found within the worksheets, move all the rows with that header to the master after last used cell in column A. If a new header is found on another worksheet, create that header on the master and check all the sheets and move the data according to the headers. I've attached a sheet that might give a better example.
    Attached Files Attached Files
    If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Move Data From One Column to Another based on column headers and Row Text
    By DerbysGal in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 02-10-2014, 07:21 AM
  2. Replies: 4
    Last Post: 02-08-2014, 02:31 PM
  3. Pull data from CSV files to Excel Mater
    By dellboy232000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2013, 09:52 PM
  4. Move Data and Create Headers
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2011, 08:21 PM
  5. Create Headers From Row on Worksheet and Move Corresponding Data
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2011, 12:26 AM

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