| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting data in a workbook across multple worksheets
I have a workbook with six worksheets. Data (questions)in each worksheet are
arranged in rows, and one column is a reference number for each question. I would like to know if it is possible to sort all the tabs together using that reference number. I assume the results would have to be produced on another tab, I can't think if there is another way to do it. I know I can sort each tab individually, I am looking to sort the data in entire workbook at once across all tabs. Appreciate any suggestions or solutions. Using Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
| Formula contains same data when i Save As a workbook with another | Excel Discussion (Misc queries) | |||
| Problem making versions of a table by changing sourse data in another workbook | Excel Discussion (Misc queries) | |||
| link data to new workbook | Excel Discussion (Misc queries) | |||
| Using Excel workbook as data source for word mailmerge | Excel Discussion (Misc queries) | |||
Threaded Mode
