I have a spreadsheet with multiple sheets, how do I get the filter to reapply each time the enter key is pressed?
I have a list of items on one sheet that is arranged in other ways on different sheets, I have the auto filter set to ignore rows with no data except under the last entry, one for each definition of items.
When I add another entry to the unfiltered cell I have to click the filter reapply button each time so another blank row appears. then when done adding items on the first page I have to click the reapply button on each of the other pages to have the new information show up. Is there another way of doing this?
It would be great if a macro or something would reapply the filter for the workbook each time I hit the enter key!
Thanks for your thoughts in advance.
Thanks, here is the workbook!
column A has the filter info.
Bookmarks