Grouped Data Blocks editted to Columns of Data based off left cell value?

Just to be clear, I am new to VBA scripting for excel but I have had extensive programming training. I think this pseudocode may help.

First I'll make a new excel sheet with each of the data headers corresponding to the attributes then,

datablockcounter = 1
For i=1;i++;End of File (13657 is the last cell)
if cell B(i) != null then
copy cell B(i)
if cell A(i) = Name then
paste cell B(i) to newsheet in cell Name(datablockcounter)
else if cell A(i) = Type then
past cell B(i) to newsheet in cell Type(datablockcounter)
else if ... //do this for each attribute
end if
else datablockcounter ++
end for

the paste command I would use would need to be one such that if there is already something in that cell it simply adds it rather than pastes over it.
I guess I don't need to check an adjacent cell as I originally thought because the attribute is valued into each of the cells via merged cell.

If someone could convert my pseudocode into VBA, you would be my most favorite compiler evar! XD

Yes of course... the only reason I would provide dummy data is to keep from looking to nerdy. But because I don't care if I look nerdy I just took a small sample of the data. Sheet1 is what my data currently looks like. Sheet2 is how I was hoping to format it.

Because I understand this site isn't a "do this for me" but a place to get assistance I thought I would point out I am working on this also. I am starting a VBA script and I will update it as I go. I don't doubt that I will eventually figure this one out by myself if no one manages to figure this out. I'm new to VBA (in fact this will be my first macro programmed in VBA). I have extensive programming training in C++, Java, Basic and some Python. I can read pretty much any code and figure out what it is the program is doing. So I have been roaming the forum and looking at answers to completely unrelated questions in an attempt to find out the syntax of VBA. So far I know that I will need to start with

Please Login or Register  to view this content.

So that's what I got so far. It's not much but... not having worked in VBA before I get stuck on what I think should be the syntax and I end up forgetting what I was trying to do in the first place.

A little edit to the pseudocode above:

I have decided not to cram data into the same cell when it multiple rows are adjacent to the same attribute. Instead I will keep them in separate cells.
So when I reach the if statement that would be

If Cells(A , i) = Rules Text then

I will need a while statement that says
j = 1
while Cells (A , i+j) = Rules Text then
//add one to the datablockcounter because there will be a second cell down and I don't want to start the next data row on top of it
datablockcounter ++
//then add this block to the range that will be copied
j ++
end

This way it will copy all the cells that are associated with the Rules Text attribute in that data block will be copied together and the row counter will be incremented for each one to make sure no data is inadvertently overwritten.

MOVE THREAD REQUEST

I just noticed I originally posted this under General because I wasn't sure what path I was going to take to solve this. Now that I know I am going to be scripting something in VBA. Will one of the mods move this thread to VBA Scripting so that I may get the proper assistance?

Thanks!

Not a problem. I've been a mod on a few forums over the years. x-posts can get quite overwhelming. I'm just trying to keep things organized so that people can find my thread and I will get the answers I am looking for.

As promised I am back. I think I may actually get this done more quickly than I originally thought. I just hope when I am done it does what I think it will XD
Hopefully this will help someone since I went through the effort of posting all of this. I'll be sure to paste the final working (hopefully) marco here.

Please Login or Register  to view this content.

It's not done yet. But I did a test run. First of all I mispelled Worksheets, Worsheets. After fixing that. I get an error. Expected Sub - it highlights Ln 63

Please Login or Register  to view this content.

This line was supposed to be dataBlockCounter ++ but it didn't like that. So I made it dataBlockCounter + 1 and it autocorrected it to dataBlockCounter 1

I was going to write the while loop for Rules Text, then get back to it.

Any help is much appreciated.

So I am stuck... This is my code so far that should be working as far as I am concerned (I haven't been able to really check for logical errors because I can't get it to run):

Please Login or Register  to view this content.

When I try to run the code I get an Error box that reads:

Run-time error '1004':

Application-defined or object-defined error

As far as I can tell it isn't highlighting any certain area and I can't figure out what it would be referring too. Most of this code was hacked together from other sources as I said above. Anyone know what it may be referring too? Also, I still can't find that post about copy and paste functions. I know I don't need to select copy select paste, what is the shorter code for this?

No problem, I was glad you weren't looking for me yesterday. I had to split out early. I've taken this as far as I can. Thank you for your help! Happy Friday!

This was Solved.

Lol... It's not really a "duplicate" thread. That rule is referring to people who post exact copies in multiple threads at the same time hoping to get a super fast answer. I posted this here and after you lied and said you would assist me and then never did. I created a new post with a link to this post, as the rules say on cross-posting. Then when that thread was solved, also solving this thread. I posted a link. Completing the thread.

You may want to check the rules on common courtesy. One might say it is common courtesy to not say you are working on a solution when you clearly are not. I gave you reputation and I wish I could take it back. If you go posting "I'm working on this" another moderator or someone looking to help may think 'Hey, someone is already helping here. I may be better off helping someone else'. Then when it turns out you were lying, that person gets no assistance and you have essentially killed a thread. Almost immediately after posting a much need revised post, I got the help I needed and my problem was solved. Something you failed to do. And as far as I can tell never planned on doing.

After I told you I was a Mod on several forums in the past, don't you think I know the difference between a x-post and a duplicate thread. I was pointing out that I wasn't breaking any forum rules. This was not a duplicate thread. This thread started out with me having no idea how to program something in VBA. Then as I was waiting on you to reply and search by myself, I came across the information I needed. I posted a RELATED thread. With a link to the background information. That thread is not asking the same thing I am asking in this thread. That thread is asking about the Error 1004 as the title of that thread would suggest. I don't think I deserve the "learn how to post" reply I got from you. But I got one none the less. So, now that you have got your chance to rage a little bit about nothing related to this thread. Would you please let this thread die. I have already marked it as solved. There is no need for this useless bickering you are inciting now.