Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the information from a pivot table
Hi there,
I was wondering if anyone would be kind enough to help. I have a report that I receive daily and need to total month to date lots by 2 fields which are ledger code and instrument code. I then need to use the information from the pivot to do some more calculations as its the month to date information which is important. There is an extract of the pivot below: Sum of Total Lots (Cleared) Instrument Code Ledger Code(Query 1 with Trading) Total C 0TCP1 4 0TDC1 8 C Total 12 CBO 0TAH1 196 0TJW1 10 0TPO1 24 CBO Total 230 I need to be able to do Vlookups etc on both the instrument code and ledger code for each line of the report. Is there anyway of doing this as the report is going to change daily so want to make it as automated as possible. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - stack information in columns? | Excel Discussion (Misc queries) | |||
pivot table maybe?? combining information | Excel Discussion (Misc queries) | |||
Extracting Information from A Pivot Table | Excel Discussion (Misc queries) | |||
Refresh scenario information in a pivot table | Excel Discussion (Misc queries) | |||
How to get information from a Pivot TAble without retyping? | Excel Discussion (Misc queries) |