Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am extracting actual costs monthly from P-Tree and mechanically placing
them into an Excel spreadseet by General Ledger # and Job #. Now I want to extract these $$$ and place them into a permanently designed "Budget vs Actual Spreadsheet" which has been set up for each job. The variables are that since the costs differ each month by job and/or general ledger #, no 2 months are the same making the coordinate references different each month. Is there a formula I can write into the "Budget vs Actuals Spreadsheet" that will look for matching GL#(Row) and Job # (column) in the spreadsheet of extracted data and place actual $$$'s into the "Budget vs Actual Spreadsheet"? Appreciate Very Much Your Help The Doc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help - now really stuck! File transfer problem | Excel Discussion (Misc queries) |