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

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