Anthony G.
Active Member
- Joined
- Mar 24, 2002
- Messages
- 465
Hello to All:
I have a MASTER Workbook labeled IC_Master and 10 templates: IC1, IC2 etc. (10 different users). Each of these templates contains one worksheet labeled ‘IC’. Each user, upon completion of the data entry, will place the Excel file in a network folder. The objective is to then copy and paste that information into the MASTER Workbook in one sheet (IC_Master). I had recorded a Macro that can carry this out because the data entry section of each IC user worksheet was A10:J200 but that has since changed in that users are not restricted to a specific number of rows (A:J remains unchanged). Also, the macro was specifically pointing to each of the 10 templates to open, go to the ‘IC’ tab and copy the info from A10:J200 and paste into the Master file.
I was hoping that there was a way in which the macro can look in the network folder and open anything that’s an Excel file and only copy information whereby the opened Workbook contains a Worksheet labeled IC and then paste the information into the ‘IC’ Worksheet in the Master Workbook regardless of how many rows of data are in the 10 user models. By the way, the 10 models (collectively) will never exceed more than 8-10.000 rows.
Is this possible?
Thanks…Anthony
I have a MASTER Workbook labeled IC_Master and 10 templates: IC1, IC2 etc. (10 different users). Each of these templates contains one worksheet labeled ‘IC’. Each user, upon completion of the data entry, will place the Excel file in a network folder. The objective is to then copy and paste that information into the MASTER Workbook in one sheet (IC_Master). I had recorded a Macro that can carry this out because the data entry section of each IC user worksheet was A10:J200 but that has since changed in that users are not restricted to a specific number of rows (A:J remains unchanged). Also, the macro was specifically pointing to each of the 10 templates to open, go to the ‘IC’ tab and copy the info from A10:J200 and paste into the Master file.
I was hoping that there was a way in which the macro can look in the network folder and open anything that’s an Excel file and only copy information whereby the opened Workbook contains a Worksheet labeled IC and then paste the information into the ‘IC’ Worksheet in the Master Workbook regardless of how many rows of data are in the 10 user models. By the way, the 10 models (collectively) will never exceed more than 8-10.000 rows.
Is this possible?
Thanks…Anthony
