Input screen for Excel data entry

Wismer

Board Regular
Joined
Jun 7, 2006
Messages
51
Hi,

The excel file I am working on requires me to search for telephone number and then input relevant cost and GST in the specified column of that number. Since the file contains more then one thousand phone numbers and need to be entered every month with new numbers continually added.

Is there a way that I can use a macro which will provide me a pop up window for entering the phone number first and then its Cost and GST amount and those amount will then automatically goes to the relevant row and column where that number is already existing in the workbook. And if the telephone number does not exist it should prompt me a message telling number not found or does not exist. So that I can first update that workbook and then enter the relevant amounts.

The point of all this exercise will be to reduce the amount of first searching a telephone number and then going to that specific row and column and then enter those amounts...and doing that repeatedly.

Just to add more information....my worksheets includes columns such as telephone number, person's name, cost centre, TOTAL AMOUNT, GST, other charges, account codes, sub total etc. Some of these columns contains basic addition and subtraction formulas.

I hope my question is not confusing.
Any help greatly appreciated.

Thanks
Wismer
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,226,287
Messages
6,190,059
Members
453,592
Latest member
bcexcel

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
Back
Top