Hi,
I am trying to auto filter a list (sheet1) and summarise it on Sheet2 with a macro button. The next stage I am having problems with as when I do another search (filter) the new list overfills the last list. If it is smaller result, part of the previous list is visible. Can I add to the macro so that when the button is clicked it erases all data below the start input cell and then adds the new filtered list?
I have attached a test file.
Cheers
John
Test List.xlsm
Bookmarks