They are in two separate workbooks. The macro will open workbook B and paste the value from workbook A into the correct cell location. Thanks for your help.
Hi, I'm a newbie to the forum and I'm trying to write a macro that will find the location where: Columns = Dates and Rows = Employee Names and I need to paste the % of the day the employee is working from another spreadsheet. Probably best if I illustrate
On spreadsheet A: I have the value...