harlequin2k5
06-28-2006, 05:07 PM
ok this should be a doozy for you guys
I have a spreadsheet that contains several worksheets which are added and deleted as needed
this spreadsheet tracks our active projects' cost:contract and contract billings etc.
on the summary page I have a list of the projects and each project displays its contract amount, estimated cost etc.
what I would like to do - and the only reason I would think to do this using excel is because the spreadsheets are already setup - is to have the formulas pick up the project number and stick it in the formula as the sheet name
in other words - this is the formula to get the contract amount for the project 06006
=VLOOKUP(MAX('06006'!$B$5:$B$18),'06006'!A:M,3)
each time I add a job to the list I have to copy and paste from the row above and more times than not I forget to change one of the project numbers in the formula
I've attempted to use something like
=VLOOKUP(MAX('b10'!$B$5:$B$18),'b10'!A:M,3)
where b10 is the field that contains the project number but it gives me an error or most times opens a file open dialogue
ok so now my eyes are crossed too - but if anyone has any idea about this your help is greatly appreciated - just let me know if you need more info about the formulas
I have a spreadsheet that contains several worksheets which are added and deleted as needed
this spreadsheet tracks our active projects' cost:contract and contract billings etc.
on the summary page I have a list of the projects and each project displays its contract amount, estimated cost etc.
what I would like to do - and the only reason I would think to do this using excel is because the spreadsheets are already setup - is to have the formulas pick up the project number and stick it in the formula as the sheet name
in other words - this is the formula to get the contract amount for the project 06006
=VLOOKUP(MAX('06006'!$B$5:$B$18),'06006'!A:M,3)
each time I add a job to the list I have to copy and paste from the row above and more times than not I forget to change one of the project numbers in the formula
I've attempted to use something like
=VLOOKUP(MAX('b10'!$B$5:$B$18),'b10'!A:M,3)
where b10 is the field that contains the project number but it gives me an error or most times opens a file open dialogue
ok so now my eyes are crossed too - but if anyone has any idea about this your help is greatly appreciated - just let me know if you need more info about the formulas