Hi,

I have a list in workbook one. A few columns, a few rows - nothing fancy.

In workbook two I have the same list but with only one of the columns. This info is linked to workbook one with A1=A1 in workbook one etc.

I want to insert a new row in workbook one in the middle of my list and have Excel autogenerate this inserted row in workbook two. Prefably with formulas and conditions included. Is this possible? I've tried dynamic lists unsuccsessfully. Not sure I'm doing it right, though.

Actually my list is built like several lists with headers inside the list. Looks like this:

Car
Honda
Toyota
Simca
Color
Red
White
Blue
Engine
Diesel
Gas
No floor - Flintstone engine

How do I insert a new row (color, maybe) in my source work book so workbook two gets the same update? Many thanks!

/ L