Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Add or Delete a row in specified place macro

0

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.?

Answer
Discuss

Answers

0

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.

Discuss


Answer the Question

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