Hello guys!
I am new so be forgiving
I am writing to you with a complicated macro. I need to add it to my excel in work.
Short description:
The task of this macro is to give the next offer number, but I need something to choose between who is making an offer. (dropdown list?!)
The offer number looks like this - 999-AA-12-2018 - next number will look 1000-AA-12-2018 (offer made by same person [AA - initials] like the previous one)
999 - is just next number
AA - is initials of person who is making an offer
12- is a month
2018- a year
Is this possible to make this kind of macro?
BEST,
tomasszz
Bookmarks