Hello, I cannot seem to work out the solution to the below.
I am trying to use a list of values from workbook 1 to calculate the result of a single complex formula in a workbook 2.
Essentially Workbook 2 is a profit calculating workbook, with many many variables that change on a daily basis. But basically I enter the final selling price of a product and workbook 2 will calculate the final profit figure.
Workbook 1 is a list of the various prices I eventually sold an item for. So what I would like to do is find a way to get Workbook 2 to calculate the final profit figure from the list of values in Workbook 1 and then send the final profit figure back to Workbook 1. So then i would have Workbook 1 showing the sold price and the profit figure next to eachother.
Is this possible?
I am trying to use a list of values from workbook 1 to calculate the result of a single complex formula in a workbook 2.
Essentially Workbook 2 is a profit calculating workbook, with many many variables that change on a daily basis. But basically I enter the final selling price of a product and workbook 2 will calculate the final profit figure.
Workbook 1 is a list of the various prices I eventually sold an item for. So what I would like to do is find a way to get Workbook 2 to calculate the final profit figure from the list of values in Workbook 1 and then send the final profit figure back to Workbook 1. So then i would have Workbook 1 showing the sold price and the profit figure next to eachother.
Is this possible?
