Home |
Search |
Today's Posts |
#1
|
|||
|
|||
update multiple worksheet in single book
Not a power user of Excel. Question: I have a spreadsheet that another person gave me. It has multple columns. (user id, user name, menu, security, location,etc) They want me to add 2 new columns (manager and delete). I have to update this worksheet with manager names. They want me to create a second spreadsheet with the same info, but sort it by manager as opposed by user id. They want the second new worksheet to be updated automatically when the first spreadsheet is edited. I tried making a copy of the first worksheet, both worksheets will update the same info if a select both (as a group), but if I try to sort the second sheet, of course it will not be the same. Any hints on how to do this? Thank You kim -- heatmiserkmp ------------------------------------------------------------------------ heatmiserkmp's Profile: http://www.excelforum.com/member.php...o&userid=28463 View this thread: http://www.excelforum.com/showthread...hreadid=480699 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
continuous page numbering multiple sheets of a single workbook? | Excel Worksheet Functions | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
multiple validation in a single cell | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions |