Inserting rows automatically

  • Thread starter Thread starter Parswanath Dhanadevan
  • Start date 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
 
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
 
Thanks Bernie,

I got the problem solved.

Thanks & Regards
Parswanath Dhanadevan
 
Back
Top