Macro to Copy Second Column in all sheets to new sheet

[boss1982]

hi

please i need ur help,

i want a macro to copy second column in all sheets (around 30 sheets in one excel file) to new sheet

i used the following code

Please Login or Register  to view this content.

but this one will copy second column from specific sheet to specific sheet and will over-write the copied columns, i want to copy second column from all sheets to one new sheet (must be created with macro) with paste as value only.

and all copied columns in the recently created sheet should be continuously, means

second column from first sheet
1
1
1
1
1
1

then

second column from second sheet
5
4
68
4
8
8
4
4

then

second column from third sheet
54
787
4645
13258
879
34654


sorry for the long thread
many thanks in advance

[watersev]

hi boss1982, please check attachment, the columns would go one by one, press "Run" button or run code "test"

[boss1982]

hi watersev,

its exactly same as i want, the result is as follows;

Please Login or Register  to view this content.

lets say that the result;

Please Login or Register  to view this content.

means with a lot of blanks;
one more thing plz, another code please or continue ur same code to let the result as follows;

Please Login or Register  to view this content.

[Kiran.Sunkara]

made small changes in the watersev code, this should help

Please Login or Register  to view this content.

[boss1982]

thank you very much kiran, i know that i asked alot;

after the code which you gave me (it was perfect), can u please give me continued code to delete all blanks rows then the filled one must be shift to up?

thanks

[boss1982]

it is ok thanks

i added

Please Login or Register  to view this content.

[watersev]

add this before Application.ScreenUpdating = 1 in "test" code:

Please Login or Register  to view this content.

[Kiran.Sunkara]

Hope your problem solved!

[boss1982]

sure

thank u all

[boss1982]

hi all

please i need one more help, how to choose which column will be copied?, if i want for example to copy second column + third and fifth.

this is the code for second column only;

Please Login or Register  to view this content.

thanks.

[boss1982]

any one can help plz?

[boss1982]