Inserting/deleting rows between worksheets
 

Hi there,

I have a workbook with 2 sheets in it. The second sheet just takes the
information from the first sheet and puts it into a format that I can use to
import the information into my accounting software.

Is there a way to set up my spreadsheets so that when I insert or delete a
row on the first page it automatically gets mimicked in the second page.

Thanks in advance

Inserting/deleting rows between worksheets
 

Yes. Hold down CTRL and click both sheets to select them. Any change you
make on one sheet will be done to both sheets
You can insert/delete rows/columns. Or enter data, formulas, etc.

"Klee" wrote in message
...
Hi there,

I have a workbook with 2 sheets in it. The second sheet just takes the
information from the first sheet and puts it into a format that I can use
to
import the information into my accounting software.

Is there a way to set up my spreadsheets so that when I insert or delete a
row on the first page it automatically gets mimicked in the second page.

Thanks in advance

Inserting/deleting rows between worksheets
 

When I said click both sheets, I meant click the sheet tabs


"Dave Thomas" wrote in message
. net...
Yes. Hold down CTRL and click both sheets to select them. Any change you
make on one sheet will be done to both sheets
You can insert/delete rows/columns. Or enter data, formulas, etc.

"Klee" wrote in message
...
Hi there,

I have a workbook with 2 sheets in it. The second sheet just takes the
information from the first sheet and puts it into a format that I can use
to
import the information into my accounting software.

Is there a way to set up my spreadsheets so that when I insert or delete
a
row on the first page it automatically gets mimicked in the second page.

Thanks in advance

Inserting/deleting rows between worksheets
 

Thanks Dave,

I was hoping that there was a way that I could just set it up so it would be
automatic. The problem is that the employees would be the ones adding and
deleting lines and they just won't remember to do that.

Thanks a lot for the info though because I will absolutly use from now on.

"Dave Thomas" wrote:

When I said click both sheets, I meant click the sheet tabs


"Dave Thomas" wrote in message
. net...
Yes. Hold down CTRL and click both sheets to select them. Any change you
make on one sheet will be done to both sheets
You can insert/delete rows/columns. Or enter data, formulas, etc.

"Klee" wrote in message
...
Hi there,

I have a workbook with 2 sheets in it. The second sheet just takes the
information from the first sheet and puts it into a format that I can use
to
import the information into my accounting software.

Is there a way to set up my spreadsheets so that when I insert or delete
a
row on the first page it automatically gets mimicked in the second page.

Thanks in advance

Inserting/deleting rows between worksheets
 

You could select all the sheets in a macro. You could put a button on a
toolbar. The employees would have to press the toolbar button to select all
the sheets before doing anything.

"Klee" wrote in message
...
Thanks Dave,

I was hoping that there was a way that I could just set it up so it would
be
automatic. The problem is that the employees would be the ones adding and
deleting lines and they just won't remember to do that.

Thanks a lot for the info though because I will absolutly use from now on.

"Dave Thomas" wrote:

When I said click both sheets, I meant click the sheet tabs


"Dave Thomas" wrote in message
. net...
Yes. Hold down CTRL and click both sheets to select them. Any change
you
make on one sheet will be done to both sheets
You can insert/delete rows/columns. Or enter data, formulas, etc.

"Klee" wrote in message
...
Hi there,

I have a workbook with 2 sheets in it. The second sheet just takes the
information from the first sheet and puts it into a format that I can
use
to
import the information into my accounting software.

Is there a way to set up my spreadsheets so that when I insert or
delete
a
row on the first page it automatically gets mimicked in the second
page.

Thanks in advance