I could use some help. I am looking for code to pull data from the 3rd tab, which is labeled "01" to the last tab, usually "31" and pull all of the data from cells A2 to the last row of data in my "Combined" tab, which is the 2nd tab. Each month I have new tab that get replaced for tabs 01 thru 31 with the new month, however the combined tab is always there. The combined tab has a header set up already and each new set of data from each tab needs to go to the last row. Does that make sense.
I tried looking for code or a macro only, but nothing works correctly. Any help would be greatly appreciated. I figure out code out how to split data from a master tab to different tabs, but not how to pull data in.
Thanks,
Dan
Bookmarks