Hi all,
Currently I'm pulling data from an Access database on to an excel worksheet.
It's starting to become quite big and its sometimes hard to find the data.
Is there any way that when I open excel, it will pull the data from the database - and depending on the date put it in a new worksheet?
e.g. I can have 52 worksheets representing each week of the year wk1 to wk52.. so depending on the date column it'll put the data into respective week?
Thanks in advance fior your help.
Bookmarks