Macro to update row addition/deletion across multiple worksheets

**lorigies** · 03-06-2014, 01:11 PM

Hi,

I'm new to using macros! I'm trying to write a macro that will be able to update all of the worksheets based on the data in one worksheet.

I'm going to be tracking peoples names in a "Master" worksheet and then have multiple worksheets containing data pertaining to each person listed. I want to be able to add/delete rows at random within the "Master" worksheet and have the other worksheets automatically update as well. Is this possible?? Thanks!!

Here is a sample of what I mean: Test_MasterList.xlsx

**Winon** · 03-07-2014, 03:24 AM

Hello lorigies,

...and have the other worksheets automatically update as well.

In order to update other Worksheets automatically, would cause any code to instantly effect any changes to the Master Sheet each time with each "Enter" key stroke, and I don't believe that is ideal.

Instead, I would propose that you make use of an "Up-Date" Button on the Master Sheet, which you may click as soon as you are done with your changes to the Master Sheet, as demonstrated in the attached sample Workbook.

Hope that helps.

Regards.

**Winon** · 03-07-2014, 04:22 AM

Hello lorigies,

Should you prefer to have it to update other Worksheets automatically, then try the attached sample Workbook.

Regards.

**lorigies** · 03-07-2014, 09:24 AM

Great, the up-date button solution is exactly what I was thinking of! Thank you!

**Winon** · 03-07-2014, 10:55 AM

Hi lorigies,

Thank you for the feedback.

You are welcome, glad I could help!

Thank you for adding to my Reputation.

Kindly mark this Thread as "Solved".

Regards.

Macro to update row addition/deletion across multiple worksheets

LinkBack

Thread Tools

Rate This Thread

Display

Macro to update row addition/deletion across multiple worksheets

Re: Macro to update row addition/deletion across multiple worksheets

Re: Macro to update row addition/deletion across multiple worksheets

Re: Macro to update row addition/deletion across multiple worksheets

Re: Macro to update row addition/deletion across multiple worksheets

Thread Information

Users Browsing this Thread

Similar Threads

Auto deletion of worksheets based on multiple criteria, and automatically returning values

Disabling the Deletion of Rows Across Multiple Worksheets

addition using multiple worksheets

Addition and Deletion

protect columns (prevent addition or deletion)

Bookmarks

Bookmarks

Posting Permissions