I have a nightly report that is generated in excel and I am hoping to copy a cell range from sheet James and paste it to another sheet James2 based off the current date. In column A of James2 I have dates in mm/dd/yyyy format, I am hoping to take my copied cell range from James and paste them to James2 starting in column B based on TODAYS date in column A. I am able to copy the cells based on the below code but I am unable to figure out how to paste the data in sheet James2
Workbooks("Daily Availability TEST FILE.xlsm").Worksheets("James").Range("D8:X8").Copy
Workbooks("Daily Availability TEST FILE.xlsm").Worksheets("James").Range("D8:X8").Copy