Clearing data from one worksheet to another

  • Thread starter Thread starter weedevil
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

clearing data but retaining formulas 10
Copying Data from One Worksheet to Another 2
Another Hyperlink Question 4
Formulas only calculate a result when there is matching data in ce 2
Summary Worksheet. 1
Excel Help to copy information from one row at a time to another sheet 1
Combining data from multiple worksheets into one 4
Auto Copy Data from one worksheet to another 1

Back
Top