Clearing data from one worksheet to another

W

weedevil

I am looking to build a sheet that will act as a "front page". It wil
request some information from the user, numbers and text only.

I want this data to be transferred to a particular row address (i.e
A5, A8 and A10) in another sheet, where all the calculations an
formulae are all set up.

The data on the "front page needs to be cleared ready for the nex
entries, and the other sheet must have an additional row inserted wit
all the existing formulae to perform the calculations while al
existing entries are kept for historical purposes.

Ohhh, Is this in any way possible? Any ideas as to how I start?

Many thanks for ANY help... :confused
 
D

Dave Peterson

You put the data into A5, A8, and A10. But you only want to insert one
additional row???

If you really meant only one row, then maybe you could use just the secondary
sheet. Then use Data|Form.

You'll see that those formula cells are not available for input in the Form.

And when you add a new record, the formulas are copied down.
 
Top