Dear all

I would like to get some advice to solve one of my Excel file

I have two Excel files, which 1 is Product price , 1 is for the quotation.

I want to keep this two files separated , which Product.xlsx it keeps the current price (as it will have to update frequently) , Quotation.xlsx to do the quoation calculation and then it can send immediately to client. I do not want client to find my product net price.

Is there any way i can handle this.

Currently I have these 2 files in same workbook, and using xlookup to locate the price. After the calculation, i copy the quotation sheet and past "data" only to eliminate the formula, before i sent to client

I think there may be a better way

I do appreciate your help

Eric