excel query
This query is : Resolved
Dharam Prakash Singh
(Querist)
19 December 2010
dear all experts,
I have an excel sheet where all the data is entered for 3 different ledgers, I want to vifercated this data to display in three defferent sheet according to their respective ledgers y using an exell formulla.
I have an excel sheet where all the data is entered for 3 different ledgers, I want to vifercated this data to display in three defferent sheet according to their respective ledgers y using an exell formulla.
CA Debasish Banerjee
(Expert)
20 December 2010
What I get of your message is
You have a worksheet where data for three ledgers are available and
You want to have it on different work sheet
THEN you should
1. Sort the data as per ledger name
2. Copy ( Crtl+C) these data on three diff worksheets (Crtl+V)
3. Remove all that you do not want from each sheet
OR
1. On cell A1 place the name of the ledger you want to have on the particular worksheet
1. You should use =IF command with cell A1 condition which will actually help you filter the name as per your demand
2. This will be repeated for each of the ledgers separately on each worksheet for all the three different ledger accounts
You have a worksheet where data for three ledgers are available and
You want to have it on different work sheet
THEN you should
1. Sort the data as per ledger name
2. Copy ( Crtl+C) these data on three diff worksheets (Crtl+V)
3. Remove all that you do not want from each sheet
OR
1. On cell A1 place the name of the ledger you want to have on the particular worksheet
1. You should use =IF command with cell A1 condition which will actually help you filter the name as per your demand
2. This will be repeated for each of the ledgers separately on each worksheet for all the three different ledger accounts
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
- Accounting treatment of AMC alongwith the purchase of Laptop
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Issuing of delivery challan by seller of goods
- Not ordinarily resident having partnership income in India and salary in USA is any form to filed be
- Nursery business
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- Tax on Amount transferred in HUF Account
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- 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
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
