Like everyone, I frequently do a spreadsheet with formulas. A
typical, simple case would be several columns (J,K,L)totaled in
another column (M), and a running total in column (N). These could be
invoices, for example, and column (A) would be successive invoice
numbers. I may have cases where two invoices erroneously had the same
number, so one was renamed (10582 becomes 10582b).

I am currently setting up a spreadsheet where invoices are being so
inputted from a prior manual system. I initially set up the sheet
with successive invoice numbers in the first column. If I need to add
a renegade invoice (by 'inserting' a new line), the new line has no
formulas in it (columns M and N)! I can copy them there manually, but
that takes time, and could result in an error if not done properly or
if I forget.

Bottom line: why don't the formulas copy automatically into the
inserted line??

I have Excel 2000, build 9.0.6926 SP-3.

Many thanks,
Lee Bowman
..

Hi Lee
In Excel 97, inserting cells with formulas can be done easly as shown below.
I am sure this can be done in Excel 2000. Please give it try & see if this
is what you want to do.

Insert moved or copied cells between existing cells

1 Select the cells that contain the data you want to move or copy.
2 To move the selection, click Cut .
To copy the selection, click Copy .
3 Select the upper-left cell where you want to place the cut or copied
cells.
4 On the Insert menu, click Cut Cells or Copied Cells.
5 Click the direction you want to shift the surrounding cells.

Hope this helps
Regards
Jed



"Lee Bowman" wrote in message
...
Like everyone, I frequently do a spreadsheet with formulas. A
typical, simple case would be several columns (J,K,L)totaled in
another column (M), and a running total in column (N). These could be
invoices, for example, and column (A) would be successive invoice
numbers. I may have cases where two invoices erroneously had the same
number, so one was renamed (10582 becomes 10582b).

I am currently setting up a spreadsheet where invoices are being so
inputted from a prior manual system. I initially set up the sheet
with successive invoice numbers in the first column. If I need to add
a renegade invoice (by 'inserting' a new line), the new line has no
formulas in it (columns M and N)! I can copy them there manually, but
that takes time, and could result in an error if not done properly or
if I forget.

Bottom line: why don't the formulas copy automatically into the
inserted line??

I have Excel 2000, build 9.0.6926 SP-3.

Many thanks,
Lee Bowman
.

Insert moved or copied cells between existing cells

1 Select the cells that contain the data you want to move or copy.
2 To move the selection, click Cut .
To copy the selection, click Copy .
3 Select the upper-left cell where you want to place the cut or copied
cells.
4 On the Insert menu, click Cut Cells or Copied Cells.
5 Click the direction you want to shift the surrounding cells.

On occasion, I'm having to put a blank row between existing rows using
right click and selecting 'insert'. The formulas in columns M & N
which progress down the columns are as follows:

FOR COLUMN 'M' =SUM(H3:J3)+F3
FOR COLUMN 'N' =SUM($K$2:$K3)

The formulas 'break' in the inserted row, and I *can* copy the
formulas there manually, *but* ......

Is there an option that makes that happen *automatically*? I'm just
trying to eliminate steps while doing a lot of data entry.

Thanks for the tips!

LB










Hope this helps
Regards
Jed



"Lee Bowman" wrote in message
...
Like everyone, I frequently do a spreadsheet with formulas. A
typical, simple case would be several columns (J,K,L)totaled in
another column (M), and a running total in column (N). These could be
invoices, for example, and column (A) would be successive invoice
numbers. I may have cases where two invoices erroneously had the same
number, so one was renamed (10582 becomes 10582b).

I am currently setting up a spreadsheet where invoices are being so
inputted from a prior manual system. I initially set up the sheet
with successive invoice numbers in the first column. If I need to add
a renegade invoice (by 'inserting' a new line), the new line has no
formulas in it (columns M and N)! I can copy them there manually, but
that takes time, and could result in an error if not done properly or
if I forget.

Bottom line: why don't the formulas copy automatically into the
inserted line??

I have Excel 2000, build 9.0.6926 SP-3.

Many thanks,
Lee Bowman
.