Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create sheet to summarise invoices on other worksheets
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create sheet to summarise invoices on other worksheets
Do 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 VBA Regards, Peo Sjoblom Regards, Peo Sjoblom " wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you create a daily diary using seperate worksheets? | Excel Discussion (Misc queries) | |||
update consolidated sheet when data is added to worksheets | Excel Discussion (Misc queries) | |||
Link Worksheets to a Master Sheet | Excel Worksheet Functions | |||
How do I create a sheet in Excel that updates itself from other sh | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |