This was my formula before we changed things
=SUMIF('F:\JGU\CLIENTS\CURRENT CLIENTS\Urban Estate Homes\Reports\[Contract Status Report.xls]Status'!$D:$D,A4,'F:\JGU\CLIENTS\CURRENT CLIENTS\Urban Estate Homes\Reports\[Contract Status Report.xls]Status'!$O:$O)
It was only having to retrieve information off of one sheet within one workbook and return the value in the cell
Now we have changed the workbook to contain several sheets (one for each year). How do I revise the above formula to search across the sheets to return the same value in the same cell.
We have a sales report that populates the value of a home in one cell when you enter the address of the residence in another cell. I need to be able to enter that address and have it search the other sheets within a separate workbook and return the information it was, before we made the change.
CLEAR AS MUD!!!! Can some one help!
=SUMIF('F:\JGU\CLIENTS\CURRENT CLIENTS\Urban Estate Homes\Reports\[Contract Status Report.xls]Status'!$D:$D,A4,'F:\JGU\CLIENTS\CURRENT CLIENTS\Urban Estate Homes\Reports\[Contract Status Report.xls]Status'!$O:$O)
It was only having to retrieve information off of one sheet within one workbook and return the value in the cell
Now we have changed the workbook to contain several sheets (one for each year). How do I revise the above formula to search across the sheets to return the same value in the same cell.
We have a sales report that populates the value of a home in one cell when you enter the address of the residence in another cell. I need to be able to enter that address and have it search the other sheets within a separate workbook and return the information it was, before we made the change.
CLEAR AS MUD!!!! Can some one help!
