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 =120700500
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 L
>
>
>
> 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
>
> *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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
