VBA: enter data in excel sheet

Hi,

I have a sheet with headers: Name, Salary, DA and Total

I am looking of a code to enter data in the sheet:

Enter name by Inputbox
Enter Salary by input box

then condition:

if Salary >=45000 then
DA = 5000
if Salary >=35000 then
DA = 3000
else
DA = 1000

and Total = Salary + DA

Main condition:

find next blank cell in sheet and enter data in continuous way....till the user end the flow

thanks
Viki

Hi davesexcel,

I have attached a workbook........

in this i need to enter name and salary by inputbox in next rows and do the automatic calculation for "DA" in "C" column.

after filling the data in one row, input box with "Name" should appear again and repeat the same step for filling the next row.

till user want.

Hi
Please find attached workbook with VBA added as follows

Please Login or Register  to view this content.

I have added comments to explain what it is doing, if these are too simplistic I apologise

Ian