hi friends i have a problem with my pakcing list in excel.
ex. i have order product1 for 10 sets, and ready for packing. and i need 10 other items for do that (which is in sheet2)...
if i select product1 from drop down list (in sheet1 ) i need all the relevant items in below as list from a15 and in from b15 total number of items for packing product1
i am using if statement for this but im not satisfied this becoz its take tooooo lengthy in each cell
b1= product1 d1= 10sets
b5= item1 item1qty item1qty for 10 sets.
b6= item2 item2qty item2qty for 10 sets
need in single sheet some products need sale item but item qty's are + or - like EX:item1=rope
product1 need 3mtr rope, Prod.2 need 5mtrs rope and product5 need 1mtr rope ...exactly like this..total 10 items..
please please i need help on this... kindly help me....plz........ im using Office 2007
Sincerely
Badboy....
Bookmarks