VBA COde For copy and paste B column of every sheets to new workbook in one sheet

[Chetan_raghu]

Hi All,


I have 150 sheets in one workbook, named like Sheet1, sheet2....sheet150, i want copy bB column from all sheet and paste in New Workbook in sheet one.


Thanks,
Chetan

[JieJenn]

Give this code a try

Please Login or Register  to view this content.

[Chetan_raghu]

Thank You very much JieJenn !!! Its working awesome you are really superstar. thanks a lot once again