Excel

This query is : Open

Querist : Anonymous

Querist : Anonymous (Querist)

22 December 2016 Sheet 1 - April 2016
Employee Basic DA HRA Total
A
B
C
D

Sheet 2 - May 2016
Employee Basic DA HRA Total
A
C
D
E

Sheet 3 - June 2016
Employee Basic DA HRA Total
A
B
C
D

Above are the sheets in a workbook for whole year for the employees salary. How to add all the details in a new worksheet for the purpose of TDS deduction.

Expert : Anonymous

Expert : Anonymous (Expert)

22 December 2016 Sir you should make a yearly sheet and than you have to use Vlookup for each month