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!

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

Mike F
"fbagirov" wrote in message
...
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!

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" wrote:

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

Mike F
"fbagirov" wrote in message
...
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!

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
"fbagirov" wrote in message
...
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" wrote:

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

Mike F
"fbagirov" wrote in message
...
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!