+ Reply to Thread
Results 1 to 6 of 6

Distributing Data from an expanding worksheet list and appending to various tabs in the sa

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Distributing Data from an expanding worksheet list and appending to various tabs in the sa

    I am trying to pull data from an expanding worksheet list that will export that data to different tabs based on the criteria.
    The YearToDate tab pulls information daily from various individual log and expense sheets so is ever growing. (Cards are assigned on a daily basis and may be used by more than one person.)
    At the end of each month, I would like to run a macro that pulls all of the information for that month and distributes it to the various worksheet tabs by card number (some of which are actually initials). This data needs to append to the existing data on each worksheet, if any so that each tab (card) will then have a running year-to-date list.
    Thanks for your help!
    ~Cdot
    Attached Files Attached Files

  2. #2
    Forum Guru 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: Distributing Data from an expanding worksheet list and appending to various tabs in th

    Hi Cdot

    Welcome to the Forum!

    Try this Code in the attached
    Please Login or Register  to view this content.
    Attached Files Attached Files
    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.

  3. #3
    Registered User
    Join Date
    11-13-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Distributing Data from an expanding worksheet list and appending to various tabs in th

    john,
    Thank you for the code you provided. It works the first time I run it but when completed, the columns stay filtered and when I add consecutive data and try to rerun the macro to move the next set of data, it doesn't seem to work or copy anything to the inidiviual worksheets.

    I am having trouble understanding the code so do not know how to edit it to select the next month.

  4. #4
    Forum Guru 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: Distributing Data from an expanding worksheet list and appending to various tabs in th

    Hi Cdot

    Here's the annotated Code...I've made the change for this
    rerun the macro to move the next set of data, it doesn't seem to work or copy anything to the inidiviual worksheets.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-13-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Distributing Data from an expanding worksheet list and appending to various tabs in th

    John,
    Thank you! thank you for the code and the annotations. It works amazingly well. I appreciate your time and help.
    ~Cdot

  6. #6
    Forum Guru 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: Distributing Data from an expanding worksheet list and appending to various tabs in th

    You're welcome...glad I could help.

    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: 1
    Last Post: 02-13-2013, 01:49 AM
  2. protected excel worksheet and an auto-expanding list
    By zc107 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2011, 10:13 PM
  3. Replies: 5
    Last Post: 08-13-2011, 11:27 AM
  4. Indirect formula using Data Validation List of Worksheet Tabs
    By Scott in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2005, 11:10 AM
  5. [SOLVED] Expanding Data validation from List
    By mark hansen in forum Excel General
    Replies: 2
    Last Post: 09-03-2005, 09:05 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