Code to Copy Formula from Sheet2 and Paste in all available Sheets in Defined Cell

Hi,

In the attached file, from A3 onward i have Formulas. From B3 onward, i have Sheet names. And from C3 onward, i have cell address into which formula is to be pasted. This cell address is EL37 and is same for all sheets.
As you can see in the attached file, cell B3=Sheet1 and C3=EL37, so code should copy formula from cell A3 and paste into cell EL37 of Sheet1. After pasting code should also drag formula from cell EL37 to Cell EL1442.
Next, As cell B4=Sheet2 and C3=EL37, so code should copy formula from cell A4 and paste into cell EL37 of Sheet2. After pasting code should also drag formula from cell EL37 to Cell EL1442. And so on,
Please see attached sample file for more clarification. (I am using Excel 2021)

Here is a code that should work.

Please Login or Register  to view this content.

Hi WideBoyDixon,

Thank you so much. It worked perfectly. Thanks again

Hi aworfolk,

Thank you for this code. It successfully pasted formulas in all sheets. But it did not drag them from cell EL37 to Cell EL1442.