[need help]Copy cells from columns to another columns in another workbook

[pangpol17]

Hi everyone, I need help from all Excel Masters to help me out in the vba code of this problem.

I have data from book1, in column B,
I want to copy that data book2, column B

example, I have data in book1, cells B5 to B100
I want to copy it to book2, cells B5 to B100

I have many files with this kind of style,
So, it may contains 10, 20 till 100 cells data
Is it possible to detect the cells that contains data?

Please help me to solve this problem.
Any help would be highly appreciated.
Thanks in advance.

 

[venkat1926]

can you not do this

right click the tab of sheet 1 in first workbook
click "move or coy"
check "create a copy at the bottom)
click the arrow at the top under "to book"
choose new book
click OK

the sheet 1 is copied as it is (including blanks and data) in the other workbook
the copied sheet name also will be the same, if you want change sheet name

 

[pangpol17]

Thanks for your help venkat1926,

But I have different style of tables in each workbook



Uploaded with ImageShack.us

SO it will detect data in workbook 1 and copy with a trigger/button to copy data to workbook 2.

Is it possible?

Thanks