sir,
i have a worksheet in that, i need following data..
Sheet (Order Form) in that i have enter item qty in different colors Column wise
A12 E12 : O12 Q12 R12 S12
1003 2 5 10 11
1005 0 11 15
1006 1 10 5
merge all above column in below condition..
merge data of column A + E:O (if having any value / skeep blank value (it must be numeric) + Q + R + S if column P is "Y".
final get data like below in FCSV file..
A B
1003 SNW Qty of E
1003 SNW Qty of F
1003 SNW Qty of G cont. end of O12.
if colum P is "Y" than
Q Qty of E
R Qty of E
S Qty of E
pls help..attached sheet for your ready reference.
also, attached vd code which is not working as per my requirement.
ragds,
Ganesh Sharma
Bookmarks