Hey Guys,
Not sure if this is possible or not:
Say we're working with 2 cells, A1 and B1, both initially blank.
If there an equation that would allow A1 to populate with today's date once B1 is populated with something?
The TODAY() function wouldn't work because then the date would change each day. I'd want it to stay static.
Any ideas?
Thanks!
You'll need a little bit of VBA.
Right click the worksheet tab, and click "View Code"
In the module which appears, enter the following:
Click File > Close and Return to Microsoft Excel
Please Login or Register to view this content.
Done
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Awesome thanks!
What if I wanted it to work for any row?
aka, if I fill in B1 I get a date in A1; fill in B2 get a date in A2; etc.
I tried changing the range in the code, but then it populated every cell in column A in that range when I just populated B1.
Looks like a simple loop worked!
Thanks again OllyPlease Login or Register to view this content.
In that case, change the code to:
Please Login or Register to view this content.
Just noticed your loop - that will be very slow! Try the amendment I just posted
Even better!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks