How do I link two workbooks/worksheets so a new row is added to each
simultaneously? I want to add a new row with data to one, then have that same
new row appear in the other sheet. Is this possible? Does it involve VBA
programming or is there a simple trick to it? Thank you for your time.

If by adding a new row of data, you mean you just type in the information on
the next avaiable row, you can link the cells in the other workbook to the
cells in the workbook where you enter the data.

=[MyBook1.xls]sheet1!A1

in the second workbook in A1 and then drag fill down and across for as many
rows as you will use.

--
Regards,
Tom Ogilvy


"Innersanctum" wrote:

How do I link two workbooks/worksheets so a new row is added to each
simultaneously? I want to add a new row with data to one, then have that same
new row appear in the other sheet. Is this possible? Does it involve VBA
programming or is there a simple trick to it? Thank you for your time.

Unfortunately it's more complicated than that. I think I may be entering into
territorty where I need to convert my Excel data into a database. I wanted to
have to workbooks linked so that if I inserted a new row of information into
the middle (let's say into row 300) of a spreadsheet with 600 rows, a new row
would also appear with that information on the 300th row of another workbook.
Cowrokers are telling be this involves VBA or may be better suited for a
database. Thoughts?
"Tom Ogilvy" wrote:

If by adding a new row of data, you mean you just type in the information on
the next avaiable row, you can link the cells in the other workbook to the
cells in the workbook where you enter the data.

=[MyBook1.xls]sheet1!A1

in the second workbook in A1 and then drag fill down and across for as many
rows as you will use.

--
Regards,
Tom Ogilvy


"Innersanctum" wrote:

How do I link two workbooks/worksheets so a new row is added to each
simultaneously? I want to add a new row with data to one, then have that same
new row appear in the other sheet. Is this possible? Does it involve VBA
programming or is there a simple trick to it? Thank you for your time.

It would definitely involve code. Of course it is a mystery why you would
want that unless you are trying to do some kind of relational database, then
it might be best to actually use a database for that.

--
Regards,
Tom Ogilvy


"Innersanctum" wrote:

Unfortunately it's more complicated than that. I think I may be entering into
territorty where I need to convert my Excel data into a database. I wanted to
have to workbooks linked so that if I inserted a new row of information into
the middle (let's say into row 300) of a spreadsheet with 600 rows, a new row
would also appear with that information on the 300th row of another workbook.
Cowrokers are telling be this involves VBA or may be better suited for a
database. Thoughts?
"Tom Ogilvy" wrote:

If by adding a new row of data, you mean you just type in the information on
the next avaiable row, you can link the cells in the other workbook to the
cells in the workbook where you enter the data.

=[MyBook1.xls]sheet1!A1

in the second workbook in A1 and then drag fill down and across for as many
rows as you will use.

--
Regards,
Tom Ogilvy


"Innersanctum" wrote:

How do I link two workbooks/worksheets so a new row is added to each
simultaneously? I want to add a new row with data to one, then have that same
new row appear in the other sheet. Is this possible? Does it involve VBA
programming or is there a simple trick to it? Thank you for your time.