• 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.

Consolidate mutiple worksheets

N

Ngoc Diep

New Member
I am preparing the consolation sheet for all my store’s orders from 4 main suppliers: VINAMILK, VIETFARM, VFOOD, BA HUAN. As a team leader, I have to combine all the information which was inputed by other 3 typers. I did try using Vlookup to get the information from other 3 sheets to the first one but I found that it was not really more efficient than just copying and pasting. However, my real data is very long so you guys please show me if having any other ways to do it. Please find the enclosed workbook.

Many thanks for your advice.
 

Attachments

Hi pecoflyer, I apprecitate your help and applied your recommened Add-in for my case. However, it did not work as I expected. Information of each sheet just stacked on each other. I continue to figure out how to make it better.
 
You must log in or register to reply here.
Back
Top