Hi Guys,

I have a workbook with multiple sheets, What I want to achieve is to adapt this macro which I'm currently using which copies a range of data from each sheet to also paste a formula into each sheet and then include the answer the formula gives in the copying process.

Please Login or Register  to view this content.
I want to paste the following formula into each sheet in cell G:950 and then copy the answer along with the other cells (D:950, E:950, F:950 & H:950)which would change the range to copy afterwards to 'D950:H950'

Please Login or Register  to view this content.
If someone has any ideas that would be fantastic thank you!