We have two Sheets one is "INVOICE" and other is "SALES". After pressing "print invoice" button , it will print and also copy to "SALES" sheet automatically . Following Code is working fine.
INVOICE :As Follow,
Date : 15/09/12 Invoice #: 717
Name : Malik Tariq - Gujranwala
Qty. Description Rate Rs.
288 Pack 1-1/2 x 8 81 23328
512 Pack 1-1/4 x 8 70 35840
Date=B6 invoice # = D6 Name=B7
Qty.= A10:A26 Description=B10:B26 (Description means "Sizes"we have more than 40 different Sizes)
SALES As Follow,
Line # 6
Invoice#=A Column , Date=B Column, Customer name=C Column, Size1=D Column, Size2=E Column , Size 3=F Column , till BB Column
Now its copying quantity after column C continiousely But we want copy invoice sheet "description " (B10:B26) to Sales sheet under relative size
Please help me its urgent
Bookmarks