banner_ad

excel query

This query is : Resolved 
Profile Image

Profile Image

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

CA Debasish Banerjee

Profile Image

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 need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
14 May 2026
Senior Accounts Executive

Karan Gupta & Co.

New Delhi

Graduate (Any)

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
10 May 2026
Finance specialist

Right way solution

Ajmer

CA

View Details
Company
14 May 2026
Senior Associate

ABHISHEK SHANKAR AGARWAL & ASSOCIATES

Kolkata

CA

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
09 May 2026
Audit Manager

Kanna and Associates

Coimbatore

CA Inter

View Details