+ Reply to Thread
Results 1 to 2 of 2

copying data from one sheet to named sheets based on list on third sheet

  1. #1
    Registered User
    Join Date
    05-13-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2013
    Posts
    1

    copying data from one sheet to named sheets based on list on third sheet

    I have a data dump. The information changes daily and I am looking to save this as a template to pull rows of information out into named tabs. I have a raw data tab with all the information. This is what would be blank and I dump the data into. So far I have 7 steps to slice the information to different tabs. Once I have the Sort Data tab, I pull that information to the Muni tab. I then pull the company names out and put them on a distributors tab which gives me a list. I can create individual tabs based on this list but now need to copy all the entries from the Sort Data tab to the individual company tabs. I am using excel 2013 and appreciate all help.

    I have attached a sample and hope for help.
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: copying data from one sheet to named sheets based on list on third sheet

    Hi Caddman2001

    Welcome to the Forum!!!

    Will the Individual Company Tabs be cleared each day as new Data Dumps are received or are the Individual Company Tabs cumulative?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 10-01-2014, 01:49 PM
  2. Macro help in copying data from multiple sheets to first Sheet of workbook based on condn
    By archies.gall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2013, 02:47 PM
  3. keep formatting when copying from named sheet to all sheets
    By pimind in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2013, 02:06 AM
  4. Replies: 0
    Last Post: 03-27-2012, 04:54 PM
  5. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:29 PM

Tags for this Thread

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