amandakay740
New Member
- Joined
- Jul 8, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
I'm attempting to paste the data from one workbook to another based on date (I've included a screenshot below as an example):
Left screenshot (source workbook):
No code help needed but a rough example of what I would use is:
Set x = Workbook 3 (source input)
Set y = Workbook 4 (source output)
x.Sheets("ProductA").Range("B3").Copy
Right Screenshot (source output)
I'd like to paste cell B3 from the source workbook into cell B7 of the source output by using the date reference. I do not want to use a last row formula because sometimes this row will be input manually before the Macro is run, so I'd like it to reference the date in the source workbook and drop it in the appropriate row of the source output workbook.
Thank you for any assistance you may have!
Left screenshot (source workbook):
No code help needed but a rough example of what I would use is:
Set x = Workbook 3 (source input)
Set y = Workbook 4 (source output)
x.Sheets("ProductA").Range("B3").Copy
Right Screenshot (source output)
I'd like to paste cell B3 from the source workbook into cell B7 of the source output by using the date reference. I do not want to use a last row formula because sometimes this row will be input manually before the Macro is run, so I'd like it to reference the date in the source workbook and drop it in the appropriate row of the source output workbook.
Thank you for any assistance you may have!