LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mark1124
 
Posts: n/a
Default calculating using 3 worksheets in a file


I have and Excel file which 3 work sheets, in the first work sheet, i
have the data in a range of cells, in the second work sheet i have
another set of data in the same range of cells as that was in the first
work sheet. I would like to add or multiply the value in the frist sheet
with value in the second sheet using the same set of ranges, the output
of this calculations, i would like to display in the third sheet in the
same cell ranges as worksheet1 and worksheet2.

Please let me know how i could do this.

MARK1123


--
mark1124
------------------------------------------------------------------------
mark1124's Profile: http://www.excelforum.com/member.php...o&userid=26400
View this thread: http://www.excelforum.com/showthread...hreadid=396775

 
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
Working with a large file, calculating after every little change brantty Setting up and Configuration of Excel 1 August 4th 05 02:01 PM
How can i synchronise worksheets in 2 different excel file... Subash M Nair. Excel Discussion (Misc queries) 1 May 4th 05 11:48 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
How to protect and unprotect 30 worksheets in a file every month . Protect & Unprotect Several Worksheets Excel Worksheet Functions 4 January 10th 05 01:29 PM
How do you print all worksheets in a file without opening the fil. timmtamm Excel Worksheet Functions 1 January 4th 05 11:50 AM


All times are GMT +1. The time now is 05:20 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"