Data from user for To the Top of a worksheet

MrACED

New Member
Joined
Nov 25, 2020
Messages
25
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,126,897
Messages
5,621,498
Members
415,845
Latest member
marej123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top