I have a workbpook with several hundred sheets including a sheet for each day of the year. The sheets named after the days are hidden. I want to open up to the sheet that matches =today() but I'm battling. I've attached a sample workbook and grateful for all help.
Hi,
Yes you could use a button to fire a macro but better still use the Workbook Open Event so that the relevant sheet is opened automatically.
You haven't told us the precise structure of the sheet tab text so I'll assume it's ddmmyyyy, e.g 29122019
The code would be
That said, why are you keeping each days data on its own sheet resulting in hundreds of sheets.
Please Login or Register to view this content.
For any serious application where you need to analyse data you should keep all data on a single sheet with an extra column to contain the record dates.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard. Thanks for that. Following up on your comment:
1. Say, I have a daily data entry sheet.
2. Say, 12 values are entered daily.
3. I have a data 'summary' sheet which is to be used to record and retain all 365 day's 12 values
How do I get the 12 values from the daily data entry sheet into the summary sheet? Is that just a copy paste approach triggered on exiting the workbook?
Hello,
As you want to make a date visible you need to make the others invisible so here
All this code goes in the ThisWorkbook Code sheetPlease Login or Register to view this content.
Grtz
Last edited by Joske920; 12-29-2019 at 07:24 PM.
Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
If you have been helped, maybe you could click the *
The best approach would be a macro that does the copying and pasting for you automatically.Originally Posted by BRISBANEBOB
We need to understand the layout of your sheets for more specific help. If you upload the workbook with say half a dozen sheets example workbook which accurately reflect the data then no doubt we can help further
I have attached a reworked sample workbook. The code I am trying to use to find the next blank cell in the summary page doesn't work. Secondly, what if the user saves twice on the same day? That would append the data again.
Hi,
This part will copy all entry and add to the data without the empty rows
To check if you already did this, maybe you could use a macro to look for all data from the date and remove it?Please Login or Register to view this content.
Grtz
T%hank you Grtz, that works perfectly. I have developed a formula solution to data already entered. Your help is much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks