LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr. Crowbar
 
Posts: n/a
Default Transfer $ of job#/Gl# on 1 s/s to 2nd s/s w/same Job#/Gl# <coord

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help - now really stuck! File transfer problem ohboy! Excel Discussion (Misc queries) 10 May 2nd 05 09:07 PM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"