Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to carry Excel balance on 1 w/s to another?

I am looking to carry a balance on one worksheet to the next. I know that the
$ is used but cannot find the format.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default How to carry Excel balance on 1 w/s to another?

Hi Sam
I'm not sure what you want but this formula =Sheet1!B20
typed in an other sheet anywhere will bring the information from Sheet1 cell
B20.
You need to change the variable to your needs.
HTH
John
"SamZ" wrote in message
...
I am looking to carry a balance on one worksheet to the next. I know that the
$ is used but cannot find the format.


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
how do i carry a balance to next row without it continuing down? Modine Charts and Charting in Excel 0 June 19th 08 11:53 PM
How do I get excel to carry over info from one cell to another? Angie Excel Worksheet Functions 1 February 7th 08 05:19 PM
How do I carry page numbers across sheets in Excel? Fireopal Excel Worksheet Functions 1 October 29th 07 08:43 PM
rent received/balance owed/running balance spreadsheet Quickbooks dummy Excel Discussion (Misc queries) 1 January 2nd 06 07:34 PM
i need a template to carry out vat returns in excel 1910809johnb Excel Worksheet Functions 0 May 4th 05 12:03 AM


All times are GMT +1. The time now is 01:22 AM.

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

About Us

"It's about Microsoft Excel"