Hi,
I'm using Excel 2013 and constantly working with lists with filter applied:
1. Selecting the filter drop-down arrow to display the filtered entries -> remove the (Select All) tick -> add the tick to the first record below (Select All) -> filter the data (OK button).
2. To show the next data set: selecting the drop-down arrow -> remove the previously ticked record -> add the tick to the next record -> filter the data (OK button)
3. Step 2 again and again until the last (Blanks) record.
I'm doing the above actions with filtered lists that have tens of entries, I'm looking for a shortcut or macro to automate the above process. Can anyone please help me out?
I'm using Excel 2013 and constantly working with lists with filter applied:
1. Selecting the filter drop-down arrow to display the filtered entries -> remove the (Select All) tick -> add the tick to the first record below (Select All) -> filter the data (OK button).
2. To show the next data set: selecting the drop-down arrow -> remove the previously ticked record -> add the tick to the next record -> filter the data (OK button)
3. Step 2 again and again until the last (Blanks) record.
I'm doing the above actions with filtered lists that have tens of entries, I'm looking for a shortcut or macro to automate the above process. Can anyone please help me out?
