Hello. I am looking to set a macro so that when the user clicks in range C6 through C100, that cell is populated with today's date, and the cursor moves one column to the right. If that is not the date the user wants, he should be able to arrow back to the cell and enter a different date.
The tab name will change each month, so hopefully the macro won't be thrown off by that.
I have attached the file for reference. Many thanks in advance!
Last edited by Canuck Chuck; 11-28-2016 at 11:55 AM.
Put this in the worksheet module:
Please Login or Register to view this content.
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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks