Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Imrac
 
Posts: n/a
Default Working across multiple worksheets


Hello!

I have some newbish questions I would like to have answered. Right now
I am working on a little project trying to work across multiple
worksheets. First work sheet will have: Col 1: Name, Col 2: Level, Col
3: Class, Col 4: Total, Col 5-X: Numbers. There are about 150-200
entries in this, but only 8 different classes. So, I would like to set
up a worksheet for each class. And I want to be able to edit one of
them, and have the new data change for the master, or visa-versa. What
can I look into to do this? Any help is greatly appreciated. Thanks in
advance

-Imrac


--
Imrac
------------------------------------------------------------------------
Imrac's Profile: http://www.excelforum.com/member.php...o&userid=33753
View this thread: http://www.excelforum.com/showthread...hreadid=535293

  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Working across multiple worksheets

You can group the sheets together,
press the ctrl button an click on the sheet tabs you want to group,
enter the information on one sheet and the rest will change, right
click on the sheet tab to ungroup the sheets

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
Search in Multiple Worksheets Lizz45ie Excel Discussion (Misc queries) 0 October 19th 05 06:22 PM
SUMif or SUMproduct across multiple worksheets? Eric Shamlin Excel Worksheet Functions 1 September 29th 05 10:55 AM
Line chart from multiple worksheets Paul B. Charts and Charting in Excel 2 September 22nd 05 12:46 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 08:48 PM
Update multiple worksheets Lizz45ie Excel Discussion (Misc queries) 0 May 31st 05 10:21 PM


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