I have multiple pivot tables showing destination cell addresses (e.g. A1) in one column and corresponding figures say $10 in another column.
I then have another worksheet where this figure has to be inputted - so in the above example I would have to go to cell A1 and input $10 manually (or else link each cell manually). Is there any way to automate this?
I then have another worksheet where this figure has to be inputted - so in the above example I would have to go to cell A1 and input $10 manually (or else link each cell manually). Is there any way to automate this?