I have an excel work book downloaded daily. The workbook contains pricing.
On occasion the pricing will move from cell to cell.
Is there a way to define the destination workbook in such a way to adapt to
the changes that might happen when the values move from one cell to another.
For example product called product 2 sometimes moves to position three in
the source workbook but its still alays called product 2. So is there a way
to have the source document auto link to the label of the destination i.e.
product 2?