Greetings Gurus,
As I have mentioned before, I am no Excel expert, but understand the basics and can understand most formulas I find on here (I just can't come up with most of them!! hah). So bear with me if there is an easy solution.
I have a client who has developed a spreadsheet with individual tabs for each day of the month (this data is pretty hard to work with).
On each tab, there are two tables. They use the tab as a template, then copy and paste the tab for the number of days in the month. So for January there are 31 tabs (worksheets) and 62 tables (31 x 2). Each tab is labeled the number of the day (1, 2, 3, 4, etc.).
I need to be able to create another tab that has the same tables as the other days, but fills in the data from the current days tab (the current day can be interpreted as System Date/Time). So on the January 5th, I need my tab to pull the data from the tab named "5"; on the 6th, it should update the data on my tab with the data from the tab named "6", and so on.
Is this possible?
Thanks in advance for your brilliance.
- misterk
Bookmarks