pawasthi
06-15-2011, 02:40 PM
Hi All,
I have more than 2 workbooks (All with different names) and these workbooks have more than 3 sheets (All with different names) in it.
1. I have pick the data from each workbook's sheet which is on place two (from sequence i.e if sheet names are A, B, C. Then I have to pick data from "B". But each workbook may have different name on Place two worksheet)
2. copy the data from row 11 to the end of the data row.
3. paste it on a different workbook sheet (Say Result sheet).
4. Then pick next workbook and repeat the steps 1-2 and paste the data on results sheet after the last row of data which was copied before this step.
Please find the attached sheets for example
Thanks for all support
I have more than 2 workbooks (All with different names) and these workbooks have more than 3 sheets (All with different names) in it.
1. I have pick the data from each workbook's sheet which is on place two (from sequence i.e if sheet names are A, B, C. Then I have to pick data from "B". But each workbook may have different name on Place two worksheet)
2. copy the data from row 11 to the end of the data row.
3. paste it on a different workbook sheet (Say Result sheet).
4. Then pick next workbook and repeat the steps 1-2 and paste the data on results sheet after the last row of data which was copied before this step.
Please find the attached sheets for example
Thanks for all support