I apologize in advance to all for these simple questions. I have read through several hundred pages of help but have still not found my answer. Here is the scenario:
I want to create a worksheet that upon opening, prompts the user for input for 2 things, a PN and date. Then I want the 3rd column to create an alpha numeric code based upon the users input PLUS the pre-existing a/n code in the row above (ie: V051005001 for the 1st event today and V051005002 for the 2nd eventtoday BUT V051105001 for the 1st event for tommorow).
I am NOT an excel expert by any means, but was recommended here by several voyuers.
Please forgive the ignorance.
Bookmarks