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

Question

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

Report

adejesus

Posts: 1
Registration date: Thursday June 15, 2017
Status: Member
Last seen: June 15, 2017

- Updated on Jun 15, 2017 at 04:57 AM
TrowaD

Posts: 2700
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: February 25, 2021

- Jun 19, 2017 at 11:27 AM

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

Make a shared file that can store data for the whole year
How to share files using utorrent - How-To - P2P
How to share files between two computers - How-To - Windows
How to share files in messenger - How-To - Facebook
File Sharing - File is not accessible. Access denied - How-To - Network
Sharing files on google drive - How-To - Google

1 reply

Ask a question

TrowaD · Answer 1 · 2017-06-19T11:27:46-0400

Answer 1 / 1

TrowaD

Posts: 2700
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: February 25, 2021

457
Jun 19, 2017 at 11:27 AM

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

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

1 reply

Your reply

Subscribe To Our Newsletter!