Hi, I have a small table(see the pic below) and I would just like to assign the corresponding date value from column B to a chosen number from column D and assign it to the variable Output1. The chosen number from column D has the same row number as the date value. I did not find anything easy except for some ugly INDEX/MATCH method. Thank you so much!
My code so far:
prtscr.JPG
Please Login or Register to view this content.
Hi,
Here is the code inside the attached that might be closer to what you want.
The Sub is triggered when you change the number in A4. I think you might really want a Function to do your work. See cell F4 for that function.Please Login or Register to view this content.
Get_Time Sub vs Function.xlsm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks