Need VBA macro code to fill the data into Salary Slip template excel sheet from input file

[Rampage598]

This is my Input File.........
and this is the template file

all the data will get fill into this template file....
But main scenario is ...

For first Employee there is no data in HRA column so then it will remove HRA from Salary slip template file

For second employee there is no data in BASIC column then it will remove BASIC from template file

can anyone give me macro code for this?

 

[Craggs82]

assuming your looping through the input file rows using a variable named "i" and with no clue of sheet names etc...

If ThisWorkbook.Sheets("Input File").Cells(1, 9) = "" Then 'HRA cell is blank
    ThisWorkbook.Sheets("Template File").Range("B9") = "" 'clear "Basic" from cell
Else
    ThisWorkbook.Sheets("Template File").Range("B9") = "Basic" 'if not then input "Basic" into cell.
End If

A simple if statement for each criteria should suffice. The above is for the 1st scenario.