pratikravani
Board Regular
- Joined
- Sep 7, 2011
- Messages
- 60
Guys:
Issue: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
Copying tabular formatted data from different worksheets of different workbooks and paste them one after another in one sheet.
Detail:<o></o>
I wanna know how to copy different Sheets of different workbooks and copy in one single sheet of the workbook I operate in. I don’t want to take the approach of coding like cells.select (which selects entire sheet) and doing so takes a lot of time to execute. In all the sheets I want to copy contain tables, so I can use the way of rows.count and make that happen. Tried but fell through.
e.g. Copying “Sheet1” and “Sheet4” from the workbook named “ABC.xlsx” and pasting in the sheets named “Input” and “Output” respectively from the workbook named “XYZ.xlsx”. Sheets to be copied have the same titles so I want to copy from row no.2 when I copy the second (Output) sheet.
The same cycle gets repeated for few more workbooks.
Any help would be appreciated.
Thanks.
Issue: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>Copying tabular formatted data from different worksheets of different workbooks and paste them one after another in one sheet.
Detail:<o
></o>I wanna know how to copy different Sheets of different workbooks and copy in one single sheet of the workbook I operate in. I don’t want to take the approach of coding like cells.select (which selects entire sheet) and doing so takes a lot of time to execute. In all the sheets I want to copy contain tables, so I can use the way of rows.count and make that happen. Tried but fell through.
e.g. Copying “Sheet1” and “Sheet4” from the workbook named “ABC.xlsx” and pasting in the sheets named “Input” and “Output” respectively from the workbook named “XYZ.xlsx”. Sheets to be copied have the same titles so I want to copy from row no.2 when I copy the second (Output) sheet.
The same cycle gets repeated for few more workbooks.
Any help would be appreciated.
Thanks.
