• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

single column of different workbooks into one

A

adeel1

Member
Hello All

in attached sheet this is format sample of work book, i have almost 70 file like this, i want only column B of all work books in one sheet with color (each worksheet merge with each color)

file destinationis as under:
C:\Users\nabeelak\Desktop\New folder
 

Attachments

  • Log (2).xlsx
    20.5 KB · Views: 8

Or you can use a property like CurrentRegion or UsedRange,
to see in inner VBA help …​
 
sorry sir marc
i am not proficient in VBA, can you give me only code here as per my requirement if you do not mind with thnx..
 
As we are not proficient as mind readers, so at least it needs
a crystal clear explanation, technical and complete !

Join source workbooks sample and the expected result workbook
exactly according from these source workbooks …
​
 
You must log in or register to reply here.
Back
Top