This is an inventory workbook. Worksheet 1's ending inventory carries over to
Worksheet 2's beginning inventory, etc.
I want to be able to insert lines for new products and have that line appear
on all the worksheets with the formulas intact.

"Gord Dibben" wrote:

What exactly do you mean by "carry over"?

A running total from sheet1 to sheet2 to sheet3 etc.?

Or you just want to insert a row in each sheet at the same time?




On Tue, 4 Dec 2007 19:25:00 -0800, roxiemayfield
wrote:

I have a workbook that has 65 worksheets. Each worksheet carries over info
from the previous worksheet. How do I insert a line in one sheet and it
carry over to the following sheets. Is there any way to do this?