|Subject:||create sheet to summarise invoices on other worksheets|
|Date:||22 May 2006|
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
Sorry I may be way off here - if anyone can give any help or make
alternative suggestions I'd be really grateful!