I am inserting data into a worksheet via a user form for one of our company quote logs.
1.) I would like the default option to insert the data at the top of the worksheet. This keeps current entry's at/near the top and then eventually move down the list as they are completed or phased out over time with new entries.
2.) I may also want the user to have the ability to place the data in a specific row, in order to get "like-quotes" or "revised quotes." It would prompt the user "On which row would you like to insert this quote?" user can enter a row # and the input data begins at that row.
3.) Is it possible to automatically insert the Data based on a custom formatted Quote #. Our format is AAA-YYYY-MMDD-00a otherwise, We would probably just run a filter&sort by quote#
AAA = Customer Abbreviation
YYY = Year
MMDD = month and day
00A = # of quote request from that customer on that day. And optional 3rd character for a revision letter.
1.) I would like the default option to insert the data at the top of the worksheet. This keeps current entry's at/near the top and then eventually move down the list as they are completed or phased out over time with new entries.
2.) I may also want the user to have the ability to place the data in a specific row, in order to get "like-quotes" or "revised quotes." It would prompt the user "On which row would you like to insert this quote?" user can enter a row # and the input data begins at that row.
3.) Is it possible to automatically insert the Data based on a custom formatted Quote #. Our format is AAA-YYYY-MMDD-00a otherwise, We would probably just run a filter&sort by quote#
AAA = Customer Abbreviation
YYY = Year
MMDD = month and day
00A = # of quote request from that customer on that day. And optional 3rd character for a revision letter.
