Moving data from cells on one excel spreadsheet to another based on a true condition

I am using a spreadsheet that contains constant data; I would like to be able to populate the cells on another spreadsheet with this data when a condition is true.

I.e. The target spreadsheet is used to prepare estimates. When the user selects a predefined price quote from the spreadsheet containing the constant data, I would like to move this data to the Estimate Spreadsheet.

Any assistance would be greatly appreciated.

Jamie

Recent Questions...