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
Bookmarks