Loop code for certain worksheets in workbook

I just googled the Internet and found some hopefully useful VBA code to find the last cell in Workbook named: HR Locations Worksheet named: 1 Mth. I hope this will help with the appending of data

Please Login or Register  to view this content.

Hi pike, thanks so much for this VBA code. I am unsure how it fits in with my code as shown above in my original post. I really do not know or understand how to use this code in the form that you have so kindly given it to me.

Is there any change please that you could be so kind as to implement your code with mine as I have no idea how to do this.

Your hard work and efforts are very much appreciated.

Kind regards,

Chris

Hello, I am trying to fix my macro is small "chunk" size pieces so that it may be easier to obtain an overall solution. The following code (once it is fixed) will help me create a loop (which I do not really know how to do) so that I can selectively choose worksheets to loop through. Could some one please help modify my code to do the following:

I am trying to create a loop that will only loop through workbook named: Book1.xls (copy attached with dummy data) 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 need the following iterations to paste the filtered data to the worksheet named: 1 Mth in the last cell (so that the data is appended).

I simply 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.

Hello again, I thought I would share my current solution of being able to loop through selective worksheets within a workbook and append the data to a destination worksheet.



My special thanks to Ron de Bruin - even though I "butchered" his excellent code

Many thanks to all those wonderful people who have kindly helped me

Cheers,

Chris

Please Login or Register  to view this content.