I am doing this for someone else at work, otherwise I would just type it myself.
Basically they want order numbers to be automatically generated in this format.
So if I did it today, and it was the first order number, it would be 0305001, and if I did it tomorrow it would I guess be 0306001 (He might want tomorrow's to be 0306002, I'm not sure, but I assume the concept is the same).
Does anyone have any advice on this? I'm admittedly not super savvy.
Thanks!
Last edited by werdnaegni; 03-05-2013 at 05:02 PM.
In A1 enter:
=TEXT(TODAY(),"mmdd") &TEXT( ROW(),"000") and copy down
Gary's Student
will all of the order numbers change tomorrow though if they were to reopen the file?
thanks
Yes!
Is that what you want??
Well I wouldn't want existing orders to change. If they made a new one, I would want THAT number to reflect the current date, but the ones I made yesterday would reflect yesterday's date. I don't even know if this is possible. Just figured I'd check.
Thanks.
Its easy!
In A1, enter a static date by touching CNTRL-;
Then in A2 enter:
=TEXT(A$1,"mmdd") &TEXT( ROWS($1:1),"000") and copy down
When tomorrow comes, say the first empty cell is A98, put the new static date in A98 and a new formula below it.
Its easy!
In A1, enter a static date by touching CNTRL-;
Then in A2 enter:
=TEXT(A$1,"mmdd") &TEXT( ROWS($1:1),"000") and copy down
When tomorrow comes, say the first empty cell is A98, put the new static date in A98 and a new formula below it.
I'll see if that will work for them. It seems like a good solution to me. Really appreciate the help, thanks!
I just don't know if they want the date there above each section of the column. I don't suppose there's a way around that though unless we stuck it over somewhere off-screen.
Could Try this :AutoOrderNumber.Sol1.xlsx
as soon as a value is entered into the highlighted area, a new order number is genereated for that customer...just an example
Hope this helps
Edit-
I only carried the formulas down to row 31, but they can be dragged as far as needed
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
It might be nice to have a marker to separate ON's by date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks