View Full Version : VBA to lookup a value, paste different value in appropriate cell

08-26-2015, 04:23 AM
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!