Loop code for selected worksheets

Hello, could some one please help modify my code to do the following:

I am trying to create a loop that will only loop through worksheets named: E-1, E-2 and E-7 only in my Excel 2003 workbook (attached with dummy data).

The AutoFilters for each of these worksheets: E-1, E-2, E-3, E-7, E-9, E-11 are switch on and have filters applied.

Upon each iteration of looping through the macro, the following line of code is executed. This code works fine for the first iteration loop, however I the following iterations to paste the filtered data to worksheet named: 1 Mth in the last cell (so that the data is appended).

I do not know how to make this happen

So if some one could please help me modify my macro and make it so that the data is appended in worksheet named 1 Mth, then it would be greatly appreciated.

Kind regards,

Chris

Please Login or Register  to view this content.

Please Login or Register  to view this content.

is this different from the prior thread on the same topic?

If not, please resume in the prior thread.