Does an if then apply here?

[loc066]

I come in peace. If I don't adhere to all the rules (Which I read), please be kind as this is my first post. If this question doesn't belong here, then please advise.

That said, here is my question:

I have a task that I do again and again in excel and thought, "Why don't I take a stab at those 'macros things' that everybody talks about." Boy was I in for a surprise.

Attached is a sample spreadsheet that I need formatted which comes to me as is in Sheet 1. On Sheet 2 is the finished product (what needs to be done). The trick is that the info on Sheet 1 comes in varying row lengths, sometimes its 100 rows, and sometimes its 30 rows and so on. Do I need variables? or an if then loop to accomplish all of this?

On sheet 3, I pasted the macro code that I did in order to get the finished product.

I tried to do this on my own and nearly went mad. I come to you with hat in hand. If I am asking for too much, then if you could point me in the right direction that would also be helpful.


Thanks