+ Reply to Thread
Results 1 to 11 of 11

looking for a macro that copy data across to its slave sheets from master sheet

  1. 05-03-2017, 07:17 PM #1
    mickgibbons1
    mickgibbons1 is offline
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    looking for a macro that copy data across to its slave sheets from master sheet

    hi all,

    i have attached a test workbook. all the cells in the master sheet are filled and run to over 40000 rows, but i have slimed down a test workbook.

    i am looking for a macro that i can attach to a button, once pressed it will take the information in Master sheet and place into there own sheets. Then when i update the master sheet, again i press the button, the macro deletes the slave sheets cells only (there are alot more other sheets)

    You will see on the Master i have columns L M, N, and O with data in (O- is showing Ref as i deleted workings, but will show 1 or 0)

    in column L you will see area 1, 2, 3 etc up to 7

    i would like the macro to take all area 1 rows, columns L, M, N and O and place information in Sheet Area 1 Columns A, B,C,D

    Then the same for Area 2, Area 3 etc

    When i press again, it removes the information in Slave sheets Area 1, 2 etc but only in Columns A B C D and not the others columns, then put the updated information in A B C D.

    thank you for reading this and i really hope i make sense as i am not very good at this.
    Attached Files Attached Files
    Last edited by mickgibbons1; 05-03-2017 at 07:30 PM.
    Reply With QuoteRegister To Reply
  2. 05-03-2017, 07:44 PM #2
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    Try and let me know

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  3. 05-03-2017, 07:53 PM #3
    mickgibbons1
    mickgibbons1 is offline
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    Leo,

    that worked a treat on the test sheet, can i ask what the macro would be if my sheets were called RIFLES, SCOTS, PWRR, LANCS, MERC, R ANG, RRF, R WEL and not Area 1 2 3 4 etc
    Reply With QuoteRegister To Reply
  4. 05-03-2017, 08:18 PM #4
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    Like this

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  5. 05-03-2017, 08:21 PM #5
    mickgibbons1
    mickgibbons1 is offline
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    Leo,

    will check it first thing in the morning when i am at work, Master will still be master (so i think i change the Rifles)

    thank you so much for your help this is amazing
    Reply With QuoteRegister To Reply
  6. 05-03-2017, 08:34 PM #6
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    Yes Yes change Rifles to master and Rifles with the others in the Array


    Cheers
    Leo
    Reply With QuoteRegister To Reply
  7. 05-04-2017, 04:42 AM #7
    mickgibbons1
    mickgibbons1 is offline
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    leo


    i have applied the Macro, to the work book, it deletes the data on the sheets and cuts across the headers from master sheet "Loaded" but none of the cells

    just so you are aware there is other names such as IG that do not have a Sheet and i dont need them to have one but i am happy to do so if its needed
    Reply With QuoteRegister To Reply
  8. 05-07-2017, 10:09 AM #8
    mickgibbons1
    mickgibbons1 is offline
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    leo


    i have applied the Macro, to the work book, it deletes the data on the sheets and cuts across the headers from master sheet "Loaded" but none of the cells

    just so you are aware there is other names such as IG that do not have a Sheet and i dont need them to have one but i am happy to do so if its needed
    Reply With QuoteRegister To Reply
  9. 05-07-2017, 05:45 PM #9
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    I'm afraid I do not understand what you mean
    so maybe show in a file


    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  10. 05-08-2017, 03:51 PM #10
    mickgibbons1
    mickgibbons1 is offline
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    111

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    hi Leo

    i have uploaded a worksheet, you will see that on sheet Master i have shaded the 3 columns i would need to transfer across to slave sheets.

    as you look at column L you will see that there are names in there that do not have a slave sheet,i need the macro to look down column L and then match the data to that slave sheet. is that possible? if not i could add slave sheets for the names that are not there.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 05-08-2017, 06:21 PM #11
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: looking for a macro that copy data across to its slave sheets from master sheet

    Try and let me know

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transferring data from master sheet to slave sheets
    By mickgibbons1 in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 12-18-2016, 03:28 PM
  2. [SOLVED] Copy data from multiple sheets to one sheet macro
    By sinapourazima in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2014, 12:49 AM
  3. Macro to copy the data from all of the sheets in one workbook over to one sheet in another
    By amweisberg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2014, 09:16 AM
  4. Need macro to copy data from one sheet and paste to many sheets
    By Gillesrd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2013, 10:39 PM
  5. 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
  6. Macro to copy and paste 70+ sheets of data onto 1 sheet
    By Helenew698 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-30-2012, 01:49 PM
  7. Macro to Copy Data from One Sheet onto Multiple Sheets
    By ssteines in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 03-03-2011, 05:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1