Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarising Worksheet Data
We have a spreadsheet that has worksheets names 06180 to 06189. I want to create a summary worksheet of some of the data. The worksheets are identical and the data that I want will always be the same. The worksheets are named 06180 to 06189. Date (H7) Supplier (B8) Purchase Order Number (H9) $ Amount (P40) I have not used macros or VBA before and I am thinking this is the only way to be able to summarise the data that I want. Also at the end of every month we use a new spreadsheet so how do make it so its easy for me to change formulas etc for a new spreadsheet?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarising Data | Excel Worksheet Functions | |||
Summarising data into a table | Excel Worksheet Functions | |||
Ways of Summarising data | Excel Discussion (Misc queries) | |||
Summarising data from several tables | Excel Worksheet Functions | |||
Summarising data | Excel Programming |