Format to be prepared based on raw data

Dear All,

Attached 2 Excel Sheets for your reference.

We will enter Model Names in Production Sheet in CG & Export_October Raw Material Details_With Combo Box excel file Starting from A37 (from Export Model) & Item names which we use for production of this model (Ex:15" Regular L/Brown is the downrod which we use for production of 56" HAYASHI BROWN/GOLD etc). Based on this, format in before sheet of excel file (VB Programming for Export Order) has to be filled automatically as shown in after sheet.

As these Models in Production Sheet will change every month. So Models, Items has to be updated dynamically with VB code.

Please let me know for any doubts and do the needful.

Regards
Anil T

Cross Posted here:

http://www.mrexcel.com/forum/excel-q...-raw-data.html


A message to forum cross posters.

Please read this:
http://www.excelguru.ca/node/7