+ Reply to Thread
Results 1 to 1 of 1

Copying (but not deleting) data from a master sheet to multiple worksheets based on Col A

  1. #1
    Registered User
    Join Date
    03-05-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Copying (but not deleting) data from a master sheet to multiple worksheets based on Col A

    Hi all,

    I've been researching this for several days now and have found a few similar examples on this and other sites, but those examples were either not quite what I've been looking for or were unanswered. I tried to alter a few different codes and only managed to get one to work (it would copy information to a second sheet, but I couldn't figure out how to alter it to copy to multiple sheets), and then after reading a few responses here I researched pivot tables and filtering, and neither of those seemed to be doing what I need either.

    Attached is a workbook that contained a master sheet (currently) three "subworksheets" to which I'd like row information to be copied based on criteria in column A. For example, if I select "Option A" from the drop-down list in Column A, it would copy the entire row (or just through Col H, which is where all my information ends) and add it to the worksheet of the same name ("Option A"). Selecting Option B sends the information to the "Option B" sheet , etc.

    I would like everything to stay on the Master TOC but also be easily viewable by option only, as there are physical copies of the listed documents in different locations and I would like to be able to quickly view and print off the updated TOC related to that specific option. Ideally it the subworksheets would automatically sort by date to have the most recent/newly added information at the top of the list instead of the bottom, but that is not really important if it complicates things too much.

    Help/suggestions would be much appreciated! And if there's a ways to stop it from selecting multiple rows when I click on one, that would be valuable information too.
    Attached Files Attached Files

+ Reply to Thread

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