I have a macro that will copy a range of cells and then paste them on every sheet in the workbook. Some of those cells have references that I want to copy over to the sheets. The references are not absolute.
My plan is to have the copied cells refer to cells on the pages in which they are being copied.
For example if cell A1 contains the reference "=A10" and A1 is being copied and pasted to Cell B2 for Sheet 2, and Sheet 3 I want Cell B2 on Sheet 2, and Sheet 3 to contain =A10.

Does any one know if this is possible?