Dear All, I am a novice when it comes to making excel sheet, and I need some help. I really appreciate everyones time. I have a new website which is generating orders, I need to consolidate orders every week and make a master excel sheet for us to process these orders. Generate master database from different workbooks, Consolidate quantities in each category against each customer with size breakup. I would like to know the formula that can be inserted, I would like to know the steps to achieve the desired results. I have attached some excel sheets in this link. Please have a look and help me. https://www.dropbox.com/s/v16tal7s12vgjjt/KTM%20orders.rar

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Creating database and inserting Vlookup formulaes

Thread starter manassampat
Start date Jan 25, 2014

manassampat

New Member

Jan 25, 2014

Dear All,

I am a novice when it comes to making excel sheet, and I need some help. I really appreciate everyones time.
I have a new website which is generating orders, I need to consolidate orders every week and make a master excel sheet for us to process these orders.

Generate master database from different workbooks,
Consolidate quantities in each category against each customer with size breakup.

I would like to know the formula that can be inserted,
I would like to know the steps to achieve the desired results.

I have attached some excel sheets in this link. Please have a look and help me. https://www.dropbox.com/s/v16tal7s12vgjjt/KTM orders.rar