Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Contents automatically entered into another cell

working on an estimate and trying to figure out a way to take the results of
one cell and have its contents be automatically entered into another cell.

I have a subtotal line item for a particular category, I am wanting to
create a cover page showing the various catergories but not all of the
breakdown. (It is simple to keep track of right now, but as the estimate
gets more involved, changes become harder to remember).

I'm trying to create a reference to the cover page that will reflect the
sub-total line item from the detailed breakdown. So, if $3.23 is shown in
the deatailed breakdown, $3.23 will show on the cover page. If any changes
come by me adding more information to the detailed breakdown, changing the
subtotal line item, the information from the sub-total line item will
automatically be updated in the cover page breakdown.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 26
Default Contents automatically entered into another cell

You can create a cell reference across different tabs/sheets.

If your sub-total line on the detailed breakdown page is say, cell A7 on
Sheet2, then on your cover page, in the cell where you want the sub-total to
be, type in:
='Sheet2'!A7

Hope this helps, Jim
Reply
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 the contents of a row when text is entered in a cell Shonzi Excel Discussion (Misc queries) 10 April 14th 07 04:13 AM
How do I get data automatically entered into a cell? rldjda Excel Worksheet Functions 1 January 18th 07 07:19 AM
preventing cell contents from being entered twice? AndyWes Excel Discussion (Misc queries) 2 May 11th 06 11:57 PM
Cell contents don't display everything entered? treybreak Excel Discussion (Misc queries) 0 April 25th 06 05:09 PM
How do I lock a cell automatically after it has data entered. Dandy Excel Discussion (Misc queries) 0 March 30th 06 12:39 PM


All times are GMT +1. The time now is 06:45 AM.

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"