Copy & Looping VBA code

[19ant]

Hi,

I have a workbook with other 100 sheets. Each sheet is identical; consists of 2 columns with the 2nd column to be copied and transposed into a mastersheet. I have created the macro to copy & transpose but cannot get the loop or repeat instruction correct. From reading many threads and other articles, it seems like a few simple lines of code but....not having success! Appreciate help and guidance.

 

[19ant]

SUCCESS! its a beautiful thing when it works, thanks very much.

For future ref: can I use the code, excluding the transpose specific code, to apply to all repetitive/looping tasks?

 

[MARK858]

It is one way that can be applied to most loops but it is not necessarily the most appropriate in all situations.

Of course in general you should avoid looping wherever possible.

Anyway happy you got it working.