Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search in Multiple Worksheets | Excel Discussion (Misc queries) | |||
SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
Line chart from multiple worksheets | Charts and Charting in Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Update multiple worksheets | Excel Discussion (Misc queries) |