inserting rows in one workbook to do the same in another workbook

[shajan]

In one work book, I constantly add rows in between Rows 8 & 14. If I add 5 rows in the raw data work book, I would like to have the same rows inserted in another work book automatically. Any ideas. Thanks.

 

[Hui]

There are two approaches to this


1. Use VBA to replicate a structure in the second workbook

2. Use Formula which are Row Independent, so that when new rows are inserted they will not skips and leave blanks, so use one of the lookup methods and use the Row number of the current workbook to refer to the Row of the source workbook

 

[prasaddn]

Hi Shajan,


You may be aware of this and also might not be applicable to your case. Just for information.


Incase you have within same workbook, but with different worksheet, then you can select the tabs (Grouping) and insert rows in one sheet, it will replicate automatically in all the sheets that were grouped.


Regards,

Prasad

 

[shajan]

Dear Hui and Prasad,

Thanks for the reply. Tabs grouping, I tried, it works fine, but is there a way to replicate the same in another workbook ? i.e I insert 5 rows in A.xlsm, it should insert the same 5 rows at the same position in B.xlsm. I am trying to consolidate data from different workbooks to one workbook.

Thanks,

Shajan.

 

[prasaddn]

i do not have the vba code but your requirement of inserting rows can be done easily thru VBA coding.


Secondly, regarding consolidation try checking this thread..

http://chandoo.org/forums/topic/consolidation


Regards,

Prasad

 

[shajan]

Thanks Prasad, Will try it out.

Regards,

Shajan.