formula or method needed
 

Hello, I use excel 97 version. I have a workbook with a few worksheets in it. I don't know if I need formulas or some type of method to achieve what I want. Please tell me the steps need to do the following
Worksheet 1 - this is what I have no
A B C D
1 3 (formula this cell) (formula this cell) (formula this cell
2 5 (formula this cell) (formula this cell
3 8 (formula this cell


When I enter a new number in cell A4, I want that same new number to automatically be inserted in cell A4 of worksheet 2, worksheet 3, etc
Then, I need in worksheet 1 the formula in cell B3 to be filled down to cell B4. Also cell C2 formula filled down to C3. And last, cell D1 filled down to D2
Now, when that is done, I want the same cells in worksheets 2, 3, etc. be filled down automatically

What I have tried: I can "fill down" manually but have too many to think about doing it that way. I have tried a macro to fill down the formulas in each worksheet but the macro always starts back to the original cell the macro started from which does not allow for additional rows to be added for ongoing data in the future, does not work
I would really appreciate any suggestions anyone has :-
Bar

formula or method needed
 

Bart,

You could write a macro to do this.
However from what I read it migth be easier to do it manually.
You could reduce the amount of work to do manually ( 4 steps only on 1 sheet
: entering a number in A4 and three copy downs).
If you *before* doing that first select all your sheets and then select A4,
input your number etc. it is done at all sheets "in one go".

As far as recording your macro is concerned, you can record your macro with
relative references rather than with absolute references as you had now.
To achieve that : activate the "stop recording" toolbar and press the button
"Relative Reference" to "toggle" between absolute / relative macro recording
mode.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Bart" wrote in message
...
Hello, I use excel 97 version. I have a workbook with a few worksheets in
it. I don't know if I need formulas or some type of method to achieve what I
want. Please tell me the steps need to do the following:
Worksheet 1 - this is what I have now
A B C
D
1 3 (formula this cell) (formula this cell) (formula this cell)
2 5 (formula this cell) (formula this cell)
3 8 (formula this cell)
4

When I enter a new number in cell A4, I want that same new number to
automatically be inserted in cell A4 of worksheet 2, worksheet 3, etc.
Then, I need in worksheet 1 the formula in cell B3 to be filled down to
cell B4. Also cell C2 formula filled down to C3. And last, cell D1 filled
down to D2.
Now, when that is done, I want the same cells in worksheets 2, 3, etc. be
filled down automatically.

What I have tried: I can "fill down" manually but have too many to think
about doing it that way. I have tried a macro to fill down the formulas in
each worksheet but the macro always starts back to the original cell the
macro started from which does not allow for additional rows to be added for
ongoing data in the future, does not work.
I would really appreciate any suggestions anyone has :-)
Bart