Excel


Avatar

Querist : Anonymous

Profile Image
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.

Avatar

Expert : Anonymous

Profile Image
Expert : Anonymous (Expert)
22 December 2016 Sir you should make a yearly sheet and than you have to use Vlookup for each month


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro

Follow us
add to google news


Answer Query



Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
ARTICLESHIP 18 June 2026
Article Assistance

RB KESHRI & CO.

Mumbai

CA Inter

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
24 June 2026
Chartered Accountant - GST & Direct Tax

APL

Mumbai

CA

View Details