Automatically fill cell with a set value on specific calendar day and time

0 votes
On a given date and time in the calendar, I want to have a cell automatically filled in with a pre-set value. Example: I want the name "John Doe" to be entered into cell A1 in the excel file on March 1, 2023, at 8:00. How to approach this? Is macro required, or are there alternative methods as well?
Feb 18 in Others by Kithuzzz
• 38,010 points
97 views

1 answer to this question.

0 votes

 Use this formula:

=IF(NOW()>DATE(2023,3,1)+TIME(8,0,0),"John Doe","")
answered Feb 18 by narikkadan
• 63,040 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
635 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,723 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 22,980 points
187 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
452 views
0 votes
1 answer

VBA Change Cell colors based on value, and it can deal with single cell and multiple cells changes

Before looping through all of the cells ...READ MORE

answered Jan 21 in Others by narikkadan
• 63,040 points
184 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP