Ask a question Report Reply to this topic

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

adejesus 1 Posts Thursday June 15, 2017Registration date June 15, 2017 Last seen - Jun 15, 2017 at 03:32 AM - Latest reply: TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen

- Jun 19, 2017 at 11:27 AM

Excel Ask a question Report Reply to this topic

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

Reply to this topic

Report Respond to TrowaD

TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen - Jun 19, 2017 at 11:27 AM

Helpful

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

Reply to this topic

Ask a question