自动在特定的日历日期和时间填充单元格为固定值。

huangapple go评论74阅读模式
英文:

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

问题

我想在特定的日历日期和时间自动填写一个单元格,填写预设的值。
示例:
在2023年03月01日08:00,我希望在Excel文件的单元格A1中填写名称'John Doe'。如何操作?是需要宏还是还有其他方法?

注:笔记本将关闭,然后在浏览器中打开(如果这一点有关的话...)。然而,它将在我考虑自动填充文本的日期上打开。一个单元格是必须的,两个单元格是对我的问题的附加部分。

英文:

I want to automatically fill in a cell with a pre-set value on a specific calendar day and time.
Example:
On the 2023-03-01 at 08:00 I want the name 'John Doe' to be filled in cell A1 in excel file. How to go about this. Is it macro that is needed or are there other ways as well?

Edit: the Notebook will be closed down and its opened in a browser (if that even matters..). However, it will be opened on the date Im thinking of auto-filling text in a cell or two. One cell being a must, two cells being a bonus addition to my question.

答案1

得分: 1

=IF(NOW()>DATE(2023,3,1)+TIME(8,0,0),"John Doe","")

英文:

You can use a formula:

=IF(NOW()>DATE(2023,3,1)+TIME(8,0,0),"John Doe","")

huangapple
  • 本文由 发表于 2023年2月17日 23:41:20
  • 转载请务必保留本文链接:https://go.coder-hub.com/75486385.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定