Syncronizing tables in different worksheets.

[Guest]

What's the easiest way to insert rows and update tables in different
worksheets (wks2, wks3), when a new record is inserted into the Master table
in Worksheet 1 ?
Thanks!

 

[Mike Fogleman]

Do you mean working with the same range in multiple sheets simultaneously?

Mike F

 

[Guest]

Yes.

I have a multiple tables in different worksheets of the same workbook.

I need to write a macro that when new VAR is added to the master table in
Sheet 1 is updated, the rest of the tables in other workbooks would also add
the same row.

I was able to write a macro that inserts new VAR into master table, but kind
of stuck on inserting into other tables.

 

[Mike Fogleman]

It is difficult to imagine how and where your tables are set up and how you
want them updated. Perhaps posting the code you have to do the master sheet
would help and describing how you want the other tables to update, would
help us give a more concise answer.

Mike F