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

[carddards]

Would the tables be displayed in the same order in sheet 1?

[loc066]

Yes they would.

Thanks for looking at my problem! and any help you provide would be highly appreciated.

[loc066]

Bump no response

[carddards]

Is there anyway you could get the tables to be placed side by side each time you use them? Or in different sheets? Or is this the only way the data would be displayed?

[loc066]

Unfortunately, the information on sheet 1 is how my program generates it. Again, it comes in varying lengths.

Is there nothing that can be done?

[carddards]

Do you get a new file each time you use it?

[loc066]

Yes, a new file is generated each time I use it. Depending on which client I run it on that is why it varies in length.

[carddards]

Is this what you want?

[loc066]

This is great!

Thank you for all the work that you put into this. There are a few areas that I needed to adjust, but given my explanation you did an excellent job.

THANKS CARDDARDS!!!!!!