| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting worksheet by column entries
I can't remember if XL97 has an issue with that method or not....
You might try starting on Sheet2 when you use the Advanced Filter and select the ranges on the other sheets, instead of using the range names. If that doesn't work, then...XL97 may have a problem referring to other sheets with the Advanced Filter. *********** Regards, Ron XL2002, WinXP-Pro "Joe" wrote: Nope ..that didnt work. :( Does this have something to do with the fact that I'm using Excel 97 ? -Joe. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Match a value from a column in worksheet | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| grand total column B from every worksheet in workbook | Excel Discussion (Misc queries) | |||
| Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) | |||
Hybrid Mode
