Hello,
I have a userform with a button that, when clicked, filters sheet1 based on listbox responses, opens up a new sheet and pastes in a table based on filtered values from sheet1. The following works fine if I only want to create one table, but I would like to be able to click the button hundreds of times and have hundreds of tables added one after the other with an empty row between them.
So, for instance, the first time the button is clicked a table spanning A1:E2 would be created based on certain filtered results on sheet1. The second time the button is clicked, a new filter would be created (this is not a problem, my code works for the filter), and I would like a new table spanning A4:E5 based on the new filter, and so forth ad infinitum.
So, if I could create a variable that increases by 3 each time I click the button, and then use that variable to define the ranges where I want the data posted, I think I would be in business. Problem is, I don't know how to go about this.
Thanks!
Bookmarks