Morning Guys,

So as far as I can tell this is a pretty complex problem... at least for someone with my limited knowledge of visual basic.

I am trying to build a macro to create a counter of sorts. I feel an example would be best. so I shall try.

I start with something along these lines:

2AEE28000355F3417407K3417407001C01

What I need to achieve is a macro that will fill up a counter but it's two fold.

2AEE28000355F3417407K3417407001C01 2AEE28000355F3417407K3417407001C02 2AEE28000355F3417407K3417407001C03 2AEE28000355F3417407K3417407001C04 2AEE28000355F3417407K3417407002C01 2AEE28000355F3417407K3417407002C02 2AEE28000355F3417407K3417407002C03 2AEE28000355F3417407K3417407002C04

I was hoping that the counter would be a variable as I want to be able to specify the number of "C" I have. i.e. it's not always 4 i need sometimes, 12, or 24.

So use column A for instance to generate my counter and input my number for C into column C.

I hope this makes sense, just home from a night shift but this is bugging me.

Any help you could offer, or clarification you require I'd be more than happy.

Thanks