Any help would be greatful!
Looking for a way using python or VBA to basically transfer data from workbook one to workbook two. The yellow cells and the light grey cells are the areas where data will be put into. I know it may show two rows, but the user is able to have multiple. As you can see there are some descriptions that are the same like name address etc, one workbook has more than the other.
So im trying to get it to basically have the user select which two workbooks to be the sources one to get from the other to paste into with similar landing spots. With that it is only from one sheet in each workbook. Then get the data from wrkbook1 to workbook 2 and everything to the right of it since the can have multiple names, address, etc, which can be 1 to 100 to 1000 cells to the right/.. Any ideas or ways to do so? There is more areas below but something to get started. Thank you!
Workbook 1
workbook 2
Looking for a way using python or VBA to basically transfer data from workbook one to workbook two. The yellow cells and the light grey cells are the areas where data will be put into. I know it may show two rows, but the user is able to have multiple. As you can see there are some descriptions that are the same like name address etc, one workbook has more than the other.
So im trying to get it to basically have the user select which two workbooks to be the sources one to get from the other to paste into with similar landing spots. With that it is only from one sheet in each workbook. Then get the data from wrkbook1 to workbook 2 and everything to the right of it since the can have multiple names, address, etc, which can be 1 to 100 to 1000 cells to the right/.. Any ideas or ways to do so? There is more areas below but something to get started. Thank you!
Workbook 1
workbook 2