Thomas Kuriakose
Active Member
Respected Sirs,
We have 70 to 80 workbooks in identical format for tools database recording. The users have filled up the required details and sent for consolidation.
We are doing this manually and this is taking a lot of time with errors and rework.
Kindly help with a code to open different workbooks and copy the data which are filled (Column B to I) to a summary tool workbook.
Kindly find attached the workbooks for your perusal.
Thank you so much,
with regards,
thomas
We have 70 to 80 workbooks in identical format for tools database recording. The users have filled up the required details and sent for consolidation.
We are doing this manually and this is taking a lot of time with errors and rework.
Kindly help with a code to open different workbooks and copy the data which are filled (Column B to I) to a summary tool workbook.
Kindly find attached the workbooks for your perusal.
Thank you so much,
with regards,
thomas