# Storing historic data in excel

#### dchopda

##### New Member
Assume that my workbook has 2 sheets, "A" and "B". Data will be uploaded in "A" and all the calculations and result finding will be done in "B". So for 1 upload in "A", 1 row in "B" will be utilized.
During the next upload, the user will delete the data from "A" first and then upload new data.
I want "B" to keep the existing data information and with the new upload generate another row of calculations.

Thanks

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### Trevor_S

##### Well-known Member
Would suggest:
• Have a single row on A (can be a hidden row) that does all the calculations and displays the results as you would want to see them on B.

• Use a macro (can be triggered by a button on A) to copy that row from A and paste values into the next available row in B. The macro could then reset A ready for the next set of data, if you want.

Last edited:

#### dchopda

##### New Member
Thank you, Ill try that and see if it works

#### Trevor_S

##### Well-known Member
If you need help with the macro, post details of:
- the actual names of both sheets
- the range in sheet A to be copied
- the first column to paste into sheet B.
I assume that row 1 of sheet B is headers, and the first row of data goes in row 2.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### Forum statistics

1,167,151
Messages
5,852,401
Members
431,504
Latest member
schoolquestion140

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back