| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can you make one worksheet update another
I have two similar worksheets within the same workbook. One sheet is sorted
by name and the other sheet is sorted by a date for a speicfic name. Is there a way to change the date on the sheet, sorted by name, and that will automatically find the name on the other sheet(sorted by date) and change the date to the second sheet? |
|
#2
|
|||
|
|||
|
Jaime,
The normal way is to have one table, and sort it as needed when needed. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Jaime S." <Jaime wrote in message ... I have two similar worksheets within the same workbook. One sheet is sorted by name and the other sheet is sorted by a date for a speicfic name. Is there a way to change the date on the sheet, sorted by name, and that will automatically find the name on the other sheet(sorted by date) and change the date to the second sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
| How do I make a sheet that combines all tabbed sheets & update as. | New Users to Excel | |||
| Update second worksheet with changes in original worksheet | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Linear Mode
