Hi there
Is there a way that a spreadsheet can recognise the date and add entries itself. I would like to add a new date entry each time it gets to a new Monday. Can the worksheet work out the date and enter it's own information.
Or if not can I tell the worksheet not to use the information until it has reached the date entered?
Hi,
You can use either approach.
An automatic macro could run every time the workbook is opened and test whether the current date is a Monday and if so (and if the current date has not already been recorded) it could add whatever it needs to add.
The other way which I think you may be getting at is to have all the Monday dates (and their associated data) present in the workbook but not visible until the current date is greater than or equal to the dates.
For more specific advice we need to know more details - preferably by seeing the workbook in question along with notes which tell us exactly what you want to happen.
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.
Thanks for your reply
I will explain a little more detail:
The worksheet is a rent account and every Monday the new rent needs to be added. Rather than going in each week and adding a new row I would like it to add itself.
The date would be in one cell then I could use the IF function to enter all the other data. If date is showing in cell then the other cells become active!!
I might be getting beyond myself now!!
I've attached the template worksheet for extra info.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks