Good Afternoon,
I have the following bit of code which gets the correct values from each tab in the workbook and puts that value in the correct cell. However, instead of this value e.g. 123,456 I would like to return a formula that says e.g. =Sheet2!C10, or =Sheet2!C50 as the case may be. In...