+ Reply to Thread
Results 1 to 8 of 8

Macro to copy/paste from master sheet to other sheets

  1. 11-15-2016, 12:06 PM #1
    jw01
    jw01 is offline
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Macro to copy/paste from master sheet to other sheets

    hi all

    seeking help on a macro. i have a workbook where i dump data from Oracle daily. I essentially want the macro to take the data in my master sheet "E,W,C Dump" and based on the district listed in column M, copy/paste the data in the respective tabs ie. East, West, Central.

    For Market, the same as above, except use master tab "Market dump" to dump data into the Market tab.

    In my master "E,W,C Dump" tab, I have listed what columns the data should copy/paste under. FYI, I only want the columns highlighted in yellow to be copy/pasted in the district tab names.

    If someone can pls help..this takes me 20 mins each day, so hoping a macro can be an easy solution. If you can kindly and please make the macro dynamic, so in the event I change the worksheet names, it does not mess up.

    thanks so much!
    Attached Files Attached Files
    Last edited by jw01; 11-16-2016 at 11:53 AM.
    Reply With QuoteRegister To Reply
  2. 11-15-2016, 12:42 PM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to copy/paste from master sheet to other sheets

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 11-15-2016, 02:36 PM #3
    jw01
    jw01 is offline
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: Macro to copy/paste from master sheet to other sheets

    Quote Originally Posted by JOHN H. DAVIS View Post
    Maybe:

    Please Login or Register  to view this content.
    Hey thanks for the macro

    I was wondering if it would be possible to limit the macro to only transfer columns A:H, K, L from the "EWC Dump" and "Market Dump" tab.

    Your current macro transfers all the columns.

    thank you!
    Reply With QuoteRegister To Reply
  4. 11-15-2016, 03:05 PM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to copy/paste from master sheet to other sheets

    Try:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 11-16-2016, 11:16 AM #5
    jw01
    jw01 is offline
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: Macro to copy/paste from master sheet to other sheets

    Quote Originally Posted by JOHN H. DAVIS View Post
    Try:

    Please Login or Register  to view this content.
    John

    This is fantastic, except for one change....for example, from the "EWC Dump" tab, column K and column L, should copy/paste in the "East" "West" "Central" tab, under column J and column I, respectively. With the current macro, column I and J in the "East" "West" "Central" tab show a blank. ALso, the same concept applies to "Market dump" tab.

    Also, would it be possible to have the data be copied over by the macro as "values" vs formula?

    thanks so much for your help!!

    FYI: i have attached the workbook with your macro, so you can see what I am referring to...thanks again!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 11-16-2016, 11:32 AM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to copy/paste from master sheet to other sheets

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 11-16-2016, 11:52 AM #7
    jw01
    jw01 is offline
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: Macro to copy/paste from master sheet to other sheets

    this works perfect...i had to change the last portion of the macro to get data from column L vs column J in the market sheet...otherwise, it works great

    thank you so so much!
    Reply With QuoteRegister To Reply
  8. 11-16-2016, 12:12 PM #8
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to copy/paste from master sheet to other sheets

    You're welcome. Glad to help out and thanks for the feedback.
    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. Macro to copy data from column and paste it on master sheet
    By Matt2014 in forum Excel General
    Replies: 1
    Last Post: 12-11-2015, 05:53 PM
  2. Copy and Paste data automatically from master sheet to other sheets
    By wschleis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 04:29 PM
  3. Copy/paste data from different work sheets to master sheet
    By Guckmall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2013, 08:23 AM
  4. [SOLVED] Macro Copy, Paste Transpose to Master Sheet
    By dingo7448 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2013, 04:15 PM
  5. [SOLVED] Copy paste values from sheets into one master sheet
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-20-2013, 10:52 AM
  6. Help with Copy and Paste Macro from Master sheet to other sheets
    By Livetorace27 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2013, 03:19 PM
  7. [SOLVED] Macro to copy paste Tables to Master sheet
    By dawnmau in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 06:48 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