Add or Delete a row in specified place macro


I created a workbook with 10 Sheets. In Sheet1 Coloum A, Coloum B, Coloum C .... contains some formulae. Sheet2, Sheet3 ..... sheet10 reflects these formulae that specified in Sheet1 and also contains so many other formulae.

How to add and delete a row in sheet1that reflects in all others sheets2 to 10.?




I actually just made a tutorial on this that's not released yet. You need to group the worksheets.

Hold Ctrl and click the tabs of the sheets to include and then edit one sheet and it will be repeated on the other sheets. 

Do this on a test file first though so you don't accidentally delete important data.


Answer the Question

You must create an account to use the forum. Create an Account or Login