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