Macro to Copy Many Columns Contents and Combing them in 1 column

Was looking into this, but basically i have a repetitive task of copying contents from various columns, and pasting them into 1 column.

1 right after the other. I figured there could be a way for a macro to copy contents from multiple columns and paste them into 1 column.

I have including 2 files, 1 from the start of the file, and 1 how it should be so it will have clarify what i am trying to do.

So basically if you open book1 , i have factory install tabs,

I need the columns contents from the first tab the (5k-20k) starting with Column B, then E, then H, and so on( Every 3rd column starting with B ) to be copied and pasted in Column A of the (Factory Install Tab) ( last tab ).

If you open the 2nd file this will be clearly understood. In the second file in the factory install tab you will notice i did the first 2. I highlighted each starting part in yellow just so its easier to see. SO in column A you should have all the contents in the 5k-20k tab ( starting with b every 3rd ), pasted in column A 1 after the other.

The next tab is the 30k tab, i need all of the columns contents copied starting with B ( every 3rd again ), copied in Column C of the Factory Install tab. Basically every tab's contents needs to have its own column in the Factory Install tab.

If anyone could help that would be great, this is a very time consuming process manually, and it would seem like a macro could be made to easily copy contents.

Thanks

Works Perfectly, in copying all the data into 1 column from all sheets. But i was also wondering if each tab could be displayed in a seperate column . For Example i wanted the 30k tab to be displayed in Column C, the 60k Tab in Column E, ( every other column in other words , that way if i find a problem with a certain tab, i can just go to the column and find the mistake . Otherwise i will have 12000 rows of data all the tabs in 1 column instead of seperated. If not i understand.


Also could u describe the process of how this is working? the reason i ask if suppose i add sheets after the factory install tab, will it copy those, or if i add sheets before the 5k 20k sheets. Because some files i work with have other tabs before and after which i do not need to copy over. ( if there is an easy way to specify which tabs to do this with perhaps? ). Also if i change the names of any tabs does it effect this macro.

Thanks

i just noticed RYU that the copied contents ( the numbers are not displaying 2 decimal places like the original tabs had on some areas. i believe this is due to the fact that it just paste specialed values and not the formats also. ( not sure though, but those numbers needs to be the same format ( decimal places ect ) , as the original tab. Ok i think i figured that part out, did a pastevalues and number formats.

Please Login or Register  to view this content.

actually this is perfect as it is, love this, thanks again RYLO! you rock.