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
- Reporting Income under Section 44ADA
- Itr 1 processing
- Building and other construction workers welfare cess act 1996
- Bank Accounts in Balance Sheet for ITR 3
- ITR validation error - Balance sheet is not filled
- ITR 1: Details for showing Exempt Income
- TDS ON CASH WITHDRAWALS...
- NRE Interest Income applicability
- Annual return of gst limit
- Bank accounts of Non resident
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- 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
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
