If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Advanced Filter in Shared Workgroup?
Is there anyway to get an advanced filter to work in a
shared workbook? If not, is there an alternative to advanced filtering that I could use? Thanks, Three20Three |
#2
|
|||
|
|||
Advanced Filter in Shared Workgroup?
You could filter the results to a different workbook:
1. Create a new blank workbook 2. Choose DataFilterAdvanced Filter 3. Select Copy to another location 4. Activate the shared workbook, and select the list range 5. Select the criteria range (in either workbook) 6. Select a 'Copy to' location 7. Click OK Three20Three wrote: Is there anyway to get an advanced filter to work in a shared workbook? If not, is there an alternative to advanced filtering that I could use? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|