Inserting rows automatically

[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

 

[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

 

[Parswanath Dhanadevan]

Thanks Bernie,

I got the problem solved.

Thanks & Regards
Parswanath Dhanadevan