LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default data from sheet to sheet automatically

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate sheet, autonumber sheet, record data on another sheet des-sa[_2_] Excel Worksheet Functions 0 May 8th 08 06:56 PM
Moving data automatically on the same sheet JDB Excel Discussion (Misc queries) 1 April 23rd 08 10:41 AM
How to Automatically transfer specific Data from Sheet 1 to Sheet Jman Excel Worksheet Functions 12 May 10th 07 05:35 AM
create a formula in one sheet that would read data from separate sheet automatically QD Excel Discussion (Misc queries) 0 December 8th 06 04:17 AM
can entered data in sheet 1 be automatically pasted in sheet 2 Adnan Jahangir Excel Discussion (Misc queries) 1 February 23rd 06 10:06 AM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"