Summary Sheet

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top