create sheet to summarise invoices on other worksheets

Giganews Newsgroups
Subject: create sheet to summarise invoices on other worksheets
Posted by:  lizsharpl…@googlemail.com
Date: 22 May 2006

Hi

I have one file containing multiple worksheets. Each worksheet contains
one invoice and I want to create a separate worksheet that pulls
details such as inv number, date, net, vat and total from all the other
sheets. Each invoice layout is exactly the same.

I have created one row in the summary worksheet containing all the info
I need from the first invoice worksheet. Is there a way that I can copy
and paste that row but get it to increment to the next worksheet each
time?

Sorry I may be way off here - if anyone can give any help or make
alternative suggestions I'd be really grateful!

Thanks

Liz

Replies