-
VBA to lookup a value, paste different value in appropriate cell
Good day to all,
I am looking for some help please, to have VBA lookup a value in sheet 2 (Cell D4), find that value in column B of sheet1, and paste the value in cell E6 of sheet1, into the cell of the row determined in sheet1, but also in the column with todays date as heading. So sheet1 has numbers going down in column B, starting in cell B2, and dates as headings from C1:FG1, starting at 1 Jan 2015. So the intercept cell for the row determined and todays date must receive the value which is in cell E6 of sheet 1.
all and any help will be appreciated and accepted with the utmost of humility and respect. Thanks to all!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules