Results 1 to 36 of 36

Transferring data from master sheet to slave sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Transferring data from master sheet to slave sheets

    hi all,

    i am after a macro to transfer data from one sheet to another based on a column. Please see attached


    So i have 6 sheets

    Complete Data (master)
    here i will cut and paste or add more rows when i get the information comes in. i would say i would have around 500 rows max

    in Column F i give the person a catergory.

    once i select that catergory i would like the whole row of that information to transfer to that catagory sheet

    example: i place Unknown 1 in Column F, that goes to unknown 1 sheet

    Hope that makes sense
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Master/Slave checkboxes
    By ko6ux in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2014, 08:48 AM
  2. Copy ranges of data from Master Sheet to Slave Sheets
    By mike.haley in forum Excel General
    Replies: 0
    Last Post: 01-23-2013, 12:51 PM
  3. Data between master and slave worksheets
    By estimatingguy in forum Excel General
    Replies: 0
    Last Post: 10-14-2011, 11:47 AM
  4. Help: transferring rows from a master sheet
    By ashncg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2011, 12:40 PM
  5. Master and slave workbooks
    By Lizzietish11 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-31-2009, 02:21 PM
  6. Transferring Data from many sheets to a single sheet
    By mohitspamz in forum Excel General
    Replies: 10
    Last Post: 09-26-2009, 03:08 AM
  7. Master/slave files
    By Dohmaker in forum Excel General
    Replies: 1
    Last Post: 02-05-2008, 02:51 PM

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