How Do I put raw data into template and regurgitate the final merged cell product?

[Snaybot]

I have included an attachment that Im trying to set up


I need help programming this template

In the example tab I have included sample data

In the Example tab

Column A is the step number
Column C is the raw data

And Columns D and E or Columns "COLUMN1 and COLUMN2"
are stuff spit out by template


In the Compilation Tab

Starting with F5 and down is the Rawdata Table

B2 and C2 are are spit out by the Sequence Tab which does not need to be touched





I am trying to learn how to still program this


PROBLEM AT HAND:
I have provided 2 completed examples in the example tab
with S4050 and S5000


So for S5010 I want the Cells D18 to D21 merged, and the Rawdata (C18 to C21) to be put into the Compilation cell starting with F5
and the regurgitated B2 and C2 to be put in to merged cell to the right of the S5010




Is there any way to do this I have literally 1000 Pages to do and automating it would be great time saver


Thanks!

[k64]

Took me a while, but is this what you want?

[Snaybot]

Wow this is amazing but the Third Rawdata Cell does not show up in the Column2

For some reason all the Third Cells are not showing up in Column1 but not in Column2

[Snaybot]

never mind im an Idiot dont listen to me

I fixed it lol

[Snaybot]

But wait the in the Example TAB I dont want any row with the Grey Bar or anthing starting with a T in ColumnA to be set to be converted using the template

[k64]

Oh, I didn't know you didn't want the "T" values to be converted. Here, this is set to only convert if it starts with "S"

[Snaybot]

Honestly you are a wizard!

I cant ask for much more

I would love to learn how you wrote this!

If you have free time, or want to train another VBA wizard id love to see an explanation of this logic

[k64]

You're welcome. It's funny, just tonight I was telling my friend about how I never posted on forums, until one time I had a question that it seemed like no one had asked. Then after posting here I was amazed at the excel wizards who responded with much better code that looked alien and worked better than mine did. I said that as I started helping other people, I think I've slowly started becoming that guy myself. Then I saw your comment.

Thank you for the plus rep and here is a commented version to explain what I'm doing. I'm sure there are better ways of checking what code does, but I always just put "Msgbox x" in the code when I want to know what x is. Be careful doing that in loops though, because you might get hundreds of message boxes.

Edit: I just noticed the #3 issue. Not sure how that happened, but easy fix.

[Snaybot]

Hey Mr.Wizard,

I got everything except this

'Set x to run from 1 to 1 past the last used row

Please Login or Register  to view this content.

How exactly is it doing this?

[k64]

End(xlup) goes up until it finds a non empty cell. By starting at A50000, I'm sure it will find the last used cell in column A. I then take the row number of that cell.

Sent from my SPH-D710 using Tapatalk