Pulling values from certain columns based on criteria from multiple sheets on the same workbook and populating in a separate workbook.

schurst44

New Member
Joined
Apr 5, 2020
Messages
11
Office Version
  1. 2010
Platform
  1. Windows
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:

Order Record.jpg


and one called "Payment Record", as follows:

Payment Record.jpg


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
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Really desperate for some advice on this please. Any help would be most appreciated. Thanks
 
Upvote 0

Forum statistics

Threads
1,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top