Excell solution - conditional formating
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
15 February 2014
Dear All,
I hv a excell sheet, there are three colomn A, B & C. A contains name of contries, b contains name of ministers all time and c contains sub ordinate officers as like follows :
A B C
India Manmohan rahul
atal bihari modi
lalu yadav mamta
US a x
b y
c z
There is big data and I need to create a diffrent worksheet for each contry means w.s. 1 india, w.s. 2 us etc by using conditional formatting.
Kindly help me in detail. Plz....
Thanks in advance.
Ram
I hv a excell sheet, there are three colomn A, B & C. A contains name of contries, b contains name of ministers all time and c contains sub ordinate officers as like follows :
A B C
India Manmohan rahul
atal bihari modi
lalu yadav mamta
US a x
b y
c z
There is big data and I need to create a diffrent worksheet for each contry means w.s. 1 india, w.s. 2 us etc by using conditional formatting.
Kindly help me in detail. Plz....
Thanks in advance.
Ram
15 February 2014
conditional formatting doesnt help you in such case..you need to use macros.
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
- House Property Reporting in ITR
- Internship/Academic shown in Salary Pay Slip of a Doctor
- TDS Claim year
- Liable to deduct tds and 44ADA
- Rent lease agreement
- TDS Challan Code
- Nomination of Bank for refund in itr 2
- Section 56(2) of the Income tax Act 1961 , Gift to relative .
- Refund of 20%pre-deposit paid for stay application
- If there is Long term capital gain exists how much total income to be considered
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
