Inserting rows automatically

  • Thread starter Parswanath Dhanadevan
  • Start date
P

Parswanath Dhanadevan

Hi,

I have a problem. I have 3 workseets in a workbook.
The first sheet contains a table. A particular column is a key column for
other worksheets also. Other worksheets also have similar table with this
key column
If I insert a row in the first sheets's between two keys how do I do the
same in other worksheets automatically?

Can someone help me in resolving this.

Thanks in advance.

Thanks & Regards,
Parswanath Dhanadevan
 
B

Bernie Deitrick

Parswanath,

If your tables are identical, row by row, then the easiest thing to do is to
group your sheets prior to inserting the row, and enter your key value
while still grouped. Otherwise, you will require a macro fired by the
worksheet change event.

Also, since you have key values, it shouldn't matter where you enter the
data.

HTH,
Bernie
MS Excel MVP
 
P

Parswanath Dhanadevan

Thanks Bernie,

I got the problem solved.

Thanks & Regards
Parswanath Dhanadevan
 
Top