software

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

LizDo you have any system in naming these sheets like default Sheet1, Sheet2 etc
or invoice1, invoice2? If so it's possible using formulas if not you would
need VBARegards,Peo SjoblomRegards,Peo Sjoblom
quot; wrote:

gt; Hi
gt;
gt; I have one file containing multiple worksheets. Each worksheet contains
gt; one invoice and I want to create a separate worksheet that pulls
gt; details such as inv number, date, net, vat and total from all the other
gt; sheets. Each invoice layout is exactly the same.
gt;
gt; I have created one row in the summary worksheet containing all the info
gt; I need from the first invoice worksheet. Is there a way that I can copy
gt; and paste that row but get it to increment to the next worksheet each
gt; time?
gt;
gt; Sorry I may be way off here - if anyone can give any help or make
gt; alternative suggestions I'd be really grateful!
gt;
gt; Thanks
gt;
gt; Liz
gt;
gt;