Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The easiest way is to select the cell where you want the value to
appear (the destination cell) and begin typing a formula - type = and then click the sheet tab for that month, put the cursor in the cell that you want to send the value from, and then press <Enter. You will have a formula that looks something like this: ='monthly total'!F25 Hope this helps. Pete On Aug 15, 5:25*pm, LosLagosGC wrote: Is there a way for me to be able to get data that I input on one worksheet automatically inserted into another worksheet... Ex: I have a yearly budget with the monthly totals, And then I have the monthly budgets with the weekly totals. Can I get it to where when the weekly totals are added up for the month, (Worksheet 1 monthly total) that the monthly total in that worksheet automatically gets inserted into the monthly total on my yearly budget (Worksheet 2 yearly total)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Moving data automatically on the same sheet | Excel Discussion (Misc queries) | |||
How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) |