-mac...@googlegroups.com]
On Behalf Of Basta
Sent: Thursday, August 06, 2009 11:41 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: auto fill start/end serial numbers and date
when qty entered
im using formula now, and i dont like filled cells, cause some people
will be confused when
im using formula now, and i dont like filled cells, cause some people
will be confused when they see many data, lots of numbers going down,
but if it possible to change fields like i found script for date auto
fill, like line by line, without copying anything,
just enter qty number and that's it.
One way to do it by formulas would be
StartSerial - Formula - "=1"Cell Format - Custom "0"
EndSerial - Formula - "=Qty" Cell Format - Custom "0"
Date- Cell Format - Custom "yymmdd"
Having done this, you can programmatically read the cell contents as
displ
