Hi All,
I have a real problem which I just cannot resolve, struggling to even know where to start to be honest!
So....
I have a workbook called "Subcontractor Order Record". Within that work book are 2 worksheets, once called "Order Record", as follows:
and one called "Payment Record", as follows:
What I am trying to do is pull specific amounts from these 2 sheets into a separate workbook called "Costs to Come" and take one from the other so that I know what costs are left to be paid.
So, I need to pull the most current value from the 'Agreed Total' column of the 'Order Record' worksheet, i.e 51,166.40 and subtract the most recent value of the 'Nett Value' column in the "Payment Record" worksheet where the corresponding row has the letter 'x' in the FPR column of the same sheet, i.e 45,600.00 because there is an 'x; in the FPR column. It's not 46,075.00 as there is not yet an 'x' in the corresponding FPR column of that row.
It needs to be future proof, because the values will change as items get added to the "Order Record" worksheet, and also when the FPR column of the "Payment Record" gets populated with 'x' as the months go on.
Does anybody know what formula I need to input into the "Costs to Come" workbook to extract that information from the "Subcontractor Order Record" workbook please?
Your help would be greatly appreciated.
Thanks
I have a real problem which I just cannot resolve, struggling to even know where to start to be honest!
So....
I have a workbook called "Subcontractor Order Record". Within that work book are 2 worksheets, once called "Order Record", as follows:
and one called "Payment Record", as follows:
What I am trying to do is pull specific amounts from these 2 sheets into a separate workbook called "Costs to Come" and take one from the other so that I know what costs are left to be paid.
So, I need to pull the most current value from the 'Agreed Total' column of the 'Order Record' worksheet, i.e 51,166.40 and subtract the most recent value of the 'Nett Value' column in the "Payment Record" worksheet where the corresponding row has the letter 'x' in the FPR column of the same sheet, i.e 45,600.00 because there is an 'x; in the FPR column. It's not 46,075.00 as there is not yet an 'x' in the corresponding FPR column of that row.
It needs to be future proof, because the values will change as items get added to the "Order Record" worksheet, and also when the FPR column of the "Payment Record" gets populated with 'x' as the months go on.
Does anybody know what formula I need to input into the "Costs to Come" workbook to extract that information from the "Subcontractor Order Record" workbook please?
Your help would be greatly appreciated.
Thanks
