asmith5rgv
Board Regular
- Joined
- Apr 6, 2006
- Messages
- 69
Good morning all. I have a XL query that goes out to our accounting software and pulls these columns:
Job1# Job Descr $ Invoiced
Job2# Job Descr $ Invoiced
Job3# Job Descr $ Invoiced
Each of the Jobs has it's own workbook that also has the $ Invoiced amount in it.
As a checking procedure I want to to run the query and have the XL sheet also go to that Job's workbook and pull the cell that has the $ invoiced amount in it to make sure my accounting software has the latest data which would look like this:.
--------This data from Query----- -----This from Workbook-----
Job1# Job Descr $ Invoiced $ Invoiced from Workbook
If I just use "=" next to the row and point to the Workbook then when the query is updated and new jobs come on or old ones go off the reference will not tie to the query row anymore.
I need some type of lookup or maybe the indirect function? ( I am not real clear on how the indirect function actually works.)
Any help is greatly appreciated.
Rgds.,
Job1# Job Descr $ Invoiced
Job2# Job Descr $ Invoiced
Job3# Job Descr $ Invoiced
Each of the Jobs has it's own workbook that also has the $ Invoiced amount in it.
As a checking procedure I want to to run the query and have the XL sheet also go to that Job's workbook and pull the cell that has the $ invoiced amount in it to make sure my accounting software has the latest data which would look like this:.
--------This data from Query----- -----This from Workbook-----
Job1# Job Descr $ Invoiced $ Invoiced from Workbook
If I just use "=" next to the row and point to the Workbook then when the query is updated and new jobs come on or old ones go off the reference will not tie to the query row anymore.
I need some type of lookup or maybe the indirect function? ( I am not real clear on how the indirect function actually works.)
Any help is greatly appreciated.
Rgds.,