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!!
Bookmarks