I still waiting for answers, Please advice I tried to made it with myself, It look like better but still have problem
see my sheet, Please help From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Attapan Sent: Wednesday, June 27, 2012 9:46 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Label record sheet Missed text (revised) On Wednesday, June 27, 2012 9:39:17 PM UTC+7, Attapan wrote: I'll explain all of my request 1.This sheet made for keep history of label printing 2.the format of label are A 1207 xxxxx line no. Month 5 digits running number 3.I've variety of product code and product code use for 3 Line// I call the name of production line = "A","B" and "T" 4. Quantity concern with running no. ex. if start new month with product a , production line a , qty = 500 ,YYMM = 1207 label which i recorded are start=A120700001 and end =A120700500 So, if I start next row with same condition (product no, production line,YYMM and qty = 30) I must be record for start=A120700501 and end=A120700530 and if I start next row with same product no, product line, YYMM = 1208 and qty 20 I must be record start=A120700001 end=A120700020 5. There are three conditions for record as I need = Product no,Production line, and YYMM Do you understand my requirement ? , Please feedback finally, Can someone advice this sheet for me ? On Wednesday, June 27, 2012 3:03:21 PM UTC+7, Attapan wrote: Dear all experts I've some questions about functions on the sheet, I made the sheet, So it use for record the label for production I tried and tried to do with many fomular, but the results are not OK :( I posted that sheet for all, Please discipline for me Very thanks Rdgs Attapan Chainarongboon Production control Dept (Compressor) Calsonic Kansei (Thailand) E-mail : attapan_chainarongb...@ck-mail.com<mailto:attapan_chainarongb...@ck-mail.com> Phone : (+66) 038-210-129 #101 Mobile phone: (+66) 086-824-5045 -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Label.xlsx
Description: Label.xlsx
