Results 1 to 8 of 8

Macro to copy/paste from master sheet to other sheets

Threaded View

  1. #1
    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.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1