K
Ket
Hello,
I have a number of separate workbooks all identically formatted. Is it
possible to create a new summary sheet that would contain the
following:
ColumnA: Cell ref C3 from each workbook
Column B: Cell ref B4 from each workbook
Column C: Range A17:B27 from each workbook
In total there are about 100 separate workbooks. After the above is
copy/pasted I would like a blank row before the next series of data.
Any VB wizards out there?
Your help is greatly appreciated.
TIA
Ket
(I am using Excel and Windows 2K)
I have a number of separate workbooks all identically formatted. Is it
possible to create a new summary sheet that would contain the
following:
ColumnA: Cell ref C3 from each workbook
Column B: Cell ref B4 from each workbook
Column C: Range A17:B27 from each workbook
In total there are about 100 separate workbooks. After the above is
copy/pasted I would like a blank row before the next series of data.
Any VB wizards out there?
Your help is greatly appreciated.
TIA
Ket
(I am using Excel and Windows 2K)