instering rows in one worksheet that reflect another worksheet
 

I have several worksheets with one master. The way I am linking each sheet to
the master is linking individual cells to the master so all the information
is on one master sheet. I know its not the best way but its a simple way for
now. My question is that if we insert a row in a worksheet how can we make
sure that row is also insterted in the master sheet as well. I know the
better way is to try to keep the rows and columns equal.
If its confusing let me know..I will try and clarify.

Thanks
T

instering rows in one worksheet that reflect another worksheet
 

How can one sheet contain all the data from several other sheets and the
rows still be the same? To answer your specific question, you can use a
Worksheet_Change macro. Within that macro, Target.Count will be equal to
Columns.Count if a row was inserted, and Target.Row will tell you what row
was inserted. Provide more detail about how you want this to work. HTH
Otto
"Tsato" wrote in message
...
I have several worksheets with one master. The way I am linking each sheet
to
the master is linking individual cells to the master so all the
information
is on one master sheet. I know its not the best way but its a simple way
for
now. My question is that if we insert a row in a worksheet how can we make
sure that row is also insterted in the master sheet as well. I know the
better way is to try to keep the rows and columns equal.
If its confusing let me know..I will try and clarify.

Thanks
T