write code to skip two tabs, create a tab, code, skip two tabs, create a tab, code, etc

[elmasguapo]

Hello. How can I write code to skip every two tabs create a new sheet, consolidate data from columns A and B in the first two tabs and place this consolidated data in column B of the newly created tab (using left row as key) and then repeating this process for the rest of the sheet? This is the code I've come up with so far but the middle section (related to the consolidate code) is wrong. How can I correct it, and get it to reference the two sheets to the left of each sheet that is created by the loop? Thanks!!

Please Login or Register  to view this content.

[skywriter]

You haven't closed the other thread and you open a new thread? How about having a little respect for someone helping you and either giving feedback as to whether you need further help, the code works or doesn't work, you are good to go or not.

[elmasguapo]

@ skywriter. What do you mean? I thanked you for the looping code and gave you feedback. I said that the code worked except for one part, which I fixed on my own. This code uses that code and adds the consolidation piece, which is what I'm asking for help on. I don't know how to write code to consolidate data and then reference the two prior sheets.

[skywriter]

You didn't read my last post, otherwise you wouldn't be asking about the 3 and it should be a 2 not a 1, and you didn't fix it.

The West coast is the best coast.
L.A. baby.

[elmasguapo]

I did read your last post. The first code that you provided worked for me. I tried it. And you're right, it's 2, not a 1--nor a 3 Thanks for your help.

[elmasguapo]

This is my second attempt but the data consolidate is still not working

Please Login or Register  to view this content.

[elmasguapo]

Mr. Skywriter!! You done done it again.