JohnBrooksBiddle
New Member
- Joined
- Jan 21, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi there,
I am trying to create a Macro that creates rows in one workbook and shifts rows down in a different workbook at the same time. I was previously able to set up my Excel workbook to reference cell data from another workbook:
My hope is that I would be able to use this same concept, and somehow work this in with the Workbook.Worksheet.Range command in VBA to trigger multiple events in these two workbooks with one Macro. Any suggestions?
I am trying to create a Macro that creates rows in one workbook and shifts rows down in a different workbook at the same time. I was previously able to set up my Excel workbook to reference cell data from another workbook:
My hope is that I would be able to use this same concept, and somehow work this in with the Workbook.Worksheet.Range command in VBA to trigger multiple events in these two workbooks with one Macro. Any suggestions?