still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 784
- Office Version
- 365
- Platform
- Windows
Hi,
In an advance filter:
Is there a way to have sheet 1 have the list range
And sheet 2 have the criteria and extract.
OR does all three have to be in the same sheet.
I tried to have the list range (“DATA”) in sheet 1
And the criteria and extract in sheet 2 but I don’t get any results
I had to copy the range "DATA" to sheet 2 to make it work
For future…does all three have to be in the same workbook
mike
In an advance filter:
Is there a way to have sheet 1 have the list range
And sheet 2 have the criteria and extract.
OR does all three have to be in the same sheet.
I tried to have the list range (“DATA”) in sheet 1
And the criteria and extract in sheet 2 but I don’t get any results
I had to copy the range "DATA" to sheet 2 to make it work
For future…does all three have to be in the same workbook
mike