Related:
- Formula to copy data from one cell
- Transfer data from one excel worksheet to another automatically - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Tmobile data check - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
2 responses
Sorry I knew this formula, but thank you,
what im looking for is a formula so when I re-enter data into a cell it copies that data to another cell.
so A1 is at 100 and this shows on cell B1
then later cell A2 becomes 150 I need cell B1 to copy A2 and keep doing this when data is entered so 100 for A1 is copies then when A2 becomes 150 it copies that then A3 becomes 200 it copies A3?
what im looking for is a formula so when I re-enter data into a cell it copies that data to another cell.
so A1 is at 100 and this shows on cell B1
then later cell A2 becomes 150 I need cell B1 to copy A2 and keep doing this when data is entered so 100 for A1 is copies then when A2 becomes 150 it copies that then A3 becomes 200 it copies A3?
Hello,
Depending on what you want to do with the data in the A column, depends on the formula. If you want to keep a running total of A1 to A4 the formula is
in cell B1
=SUM(A1:A4)
Even if the cells are empty at the moment, you may have an error warning stating that B1 refers to empty cells though.
I hope that helps
Depending on what you want to do with the data in the A column, depends on the formula. If you want to keep a running total of A1 to A4 the formula is
in cell B1
=SUM(A1:A4)
Even if the cells are empty at the moment, you may have an error warning stating that B1 refers to empty cells though.
I hope that helps
