Make a shared file that can store data for the whole year

Closed
adejesus Posts 1 Registration date Thursday 15 June 2017 Status Member Last seen 15 June 2017 - 15 Jun 2017 à 03:32
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Jun 2017 à 11:27
how can I make a shared file that can store data for the whole year and you can select the file for a specific month, day, and year? Using Macros. or if you can point me in the right direction since I've never use MACROS.

Thank you
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
19 Jun 2017 à 11:27
Hi Adejesus,

I would create a workbook for each year, a worksheet for each month and a column for each day.

Now you can easily find the right year, when you sort your files, pick the right month out of the 12 sheets and the right day out of the 29+ columns.

Best regards,
Trowa