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.
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
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- EPF ECR NEW FILE SEP 17TH 2026
- Under marginal scheme
- Import of Software Service.
- SECTION 393(3) TAX ON CASH WITHDRAWAL
- GST on Renting godown to KFCSC for Storage of Raagi
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- Oct 2025 Invoices
- TDS on Fixed Assets purchased
- Utilisation Fy 25-26 TDS challans in Fy 26-27 TDS Return
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
