Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table or something else?
Hi - I've not used pivot tables before, but I have been doing a bit of
reading and they might be what I need, might not so your advice would be useful before I get bogged down learning thanks. In workbook A I have a spreadsheet that records every purchase and payment, however made. I want to break the sheet down into individual supplier records in another workbook (I could stick to the same workbook if i had to, but it is getting big). So far, using simple functions like IF and VLOOKUP, I have created 2 sheets, 1 to record all the credit account suppliers and the other to record all the cash purchases. I had it in mind to use 1 sheet per credit supplier and simply show again the rows from Workbook A if the supplier name matched the sheet name. Obviously this would create a large number of sheets but the records would be just like having a card index and flicking to the supplier required. I tried to make a basic pivot table with the data and it failed because it references another workbook (I think) and so i question if that is the best way to go? TIA Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions |