kathleen0927
New Member
- Joined
- Feb 7, 2018
- Messages
- 32
Hi guys! I am having trouble figuring out how to do the following. Basically, I have a spreadsheet that I need to add controls to so the end user can re-sort the log based on how they want to see the data.
Rows 1:6 are headers
Print Range is A7:AG1525, but range will grow as new rows are inserted
The first sort is by Work Area and criteria is:
1. Filter data in column AE where value = Open or Work Area or Legend. All other rows are to be hidden
2. Resort the print range by Column C (low to high), then a secondary sort by Column E (low to High)
3. Hide column M
4. Unhide Column G
The second (or default view) brings the spreadsheet back to the original view by Vendor with criteria:
1. Filter data in column AE where value = Open or Legend or Vendor. All other rows are to be hiddne
2. Re-sort the Print Range by Column B (Low to High) then a secondary sort by Column E (Low to High)
3. Unhide column M
4. Hide Column G.
Any ideas? Thanks so much!
Rows 1:6 are headers
Print Range is A7:AG1525, but range will grow as new rows are inserted
The first sort is by Work Area and criteria is:
1. Filter data in column AE where value = Open or Work Area or Legend. All other rows are to be hidden
2. Resort the print range by Column C (low to high), then a secondary sort by Column E (low to High)
3. Hide column M
4. Unhide Column G
The second (or default view) brings the spreadsheet back to the original view by Vendor with criteria:
1. Filter data in column AE where value = Open or Legend or Vendor. All other rows are to be hiddne
2. Re-sort the Print Range by Column B (Low to High) then a secondary sort by Column E (Low to High)
3. Unhide column M
4. Hide Column G.
Any ideas? Thanks so much!
