Hi All,
First of all, thanks to all of the posters here, you will never know how much help you are to all of us who need the assistance and guidance you provide.
OK, on to the problem. I have a building survey project underway, I have created 2 workbooks, (Internal data & External data), stored in 2 different workbooks. (Reason being, we have 2 different surveyors who might be at the property at different times and work in different offices). All of the worksheets are named for the address of the property being surveyed. 1 internal worksheet & 1 external worksheet per property.
There are approx 400 different pieces of data being collected per property.
I have a 3rd 'master' workbook, (Combined internal & external worksheets), these combined worksheets are also named for the addresses of the properties. There might be up to 200 different properties on each scheme.
I would like to know if there is a way to use VBA to loop through the internal & external workbooks and copy all of the survey data collected on the internal & external worksheets onto the combination worksheets stored in the master workbook. This will only be done once per scheme when all of the survey data is completed.
A blanket copy from 2 ranges (1 per worksheet), would do the job, but I'm struggling to get started.
Looking through the posts on the forum it looks to be that most people need to bring lots of data onto 1 summary worksheetsheet, I need to keep the different addresses separated out. 1 address per worksheet, completed with both the internal and external data.
Any help you could provide would be helpful.
Thanks
First of all, thanks to all of the posters here, you will never know how much help you are to all of us who need the assistance and guidance you provide.
OK, on to the problem. I have a building survey project underway, I have created 2 workbooks, (Internal data & External data), stored in 2 different workbooks. (Reason being, we have 2 different surveyors who might be at the property at different times and work in different offices). All of the worksheets are named for the address of the property being surveyed. 1 internal worksheet & 1 external worksheet per property.
There are approx 400 different pieces of data being collected per property.
I have a 3rd 'master' workbook, (Combined internal & external worksheets), these combined worksheets are also named for the addresses of the properties. There might be up to 200 different properties on each scheme.
I would like to know if there is a way to use VBA to loop through the internal & external workbooks and copy all of the survey data collected on the internal & external worksheets onto the combination worksheets stored in the master workbook. This will only be done once per scheme when all of the survey data is completed.
A blanket copy from 2 ranges (1 per worksheet), would do the job, but I'm struggling to get started.
Looking through the posts on the forum it looks to be that most people need to bring lots of data onto 1 summary worksheetsheet, I need to keep the different addresses separated out. 1 address per worksheet, completed with both the internal and external data.
Any help you could provide would be helpful.
Thanks
