VBA code required

[hrayani]

Hello Friends,

In a worksheet "Master" I have the below formulas

In Range B4:B9

=IFERROR(AGGREGATE(15,6,'C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_ref/((('C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_status="In Process")*('C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_customer="abc"))*ISNA(MATCH('C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_ref,B$3:B3,0))),1),"")

In Range C4:C9

=LOOKUP(2,1/('C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_ref=$B4),'C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_po_1)

In Range G4:G9

=SUMPRODUCT(--('C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_ref=B4),'C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_quantity)

What I want is a VBA code which when run does the following

1) get the values in all 3 above mentioned columns with the formulas
2) Change the formulas to values

Regards,

Humayun

 

[Fluff]

As this is a significantly different question, from the OP's please start a thread of your own. Thanks