Search : in
By :

Formula to copy data from one cell

Last answer on Aug 3, 2009 10:55:44 am BST Nick D, on Jul 31, 2009 12:18:38 pm BST 
 Report this message to moderators

Hello,

I need a formula to Copy data from one spreadsheet to another automatically. I need it to update the most recent figure into it and copy if to another.
E.g. Cell A1 is on 100 and the formula copies that to Cell B1, but the next day i update the data into A2 and new data in A3 and next data in cell A4, i need a formula to change the figure in the cell B1 to my updates. So day one is on 100 then when i change the data on the next it will change to the new data on A2,A3 and A4?

Please can you help?

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Formula to copy data from one cell » in :
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

Simple Matt, on Aug 3, 2009 10:30:58 am BST

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

   
Reply to Simple Matt

2

 NickJDodds, on Aug 3, 2009 10:55:44 am BST
  • +1

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?

   
Reply to NickJDodds
Ask your question Reply
They need your help