Inserting/deleting rows between worksheets

K

Klee

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
 
D

Dave Thomas

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.
 
K

Klee

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.
 
D

Dave Thomas

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.
 
Top