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

Report
Posts
1
Registration date
Thursday June 15, 2017
Status
Member
Last seen
June 15, 2017
-
Posts
2700
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 25, 2021
-
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

1 reply

Posts
2700
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 25, 2021
457
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!