Copy Data in to a Filtered List in Excel - Challenge

1422 views
User Avatar

Financial Analyst
276 Points Posted on 09 June 2011

 Challenge - How do you copy data in to a filtered list in Excel 

1 Reply Share Follow
On 09 June 2011 at 20:40 Report
Replies (6)
User Avatar

accountant
321 Points Posted on 19 June 2011

by using past special options
 

Reply
On 19 June 2011 at 23:54
User Avatar

ACA ACS ACMA ACMA CGMA
22 Points Posted on 02 August 2011

Use "select visible cell" icon and copy the filtered data.

Reply
On 02 August 2011 at 16:37
User Avatar

Chartered Accountant
1796 Points Posted on 02 August 2011

Acrually its not achallenge its tutorial

Reply
On 02 August 2011 at 23:46
User Avatar

CA - Final
218 Points Posted on 19 September 2011

Dear Sir,

 

In my opinior: -

Try to Unfilter it and then try pasting the data.

Further If you require then send a sample sheet in which you require assistance.

 

Reply
On 19 September 2011 at 19:35
User Avatar

CA - Final
218 Points Posted on 15 October 2011
Originally posted by : GN Sahu

Use "select visible cell" icon and copy the filtered data.

Agreed!

Reply
On 15 October 2011 at 15:37
User Avatar

Software
1586 Points Posted on 15 October 2011

Before copy & paste to filtered data make sure that the data is properly sorted.

Reply
On 15 October 2011 at 20:45

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Topics :

  1. GST Reconciliation Tool (2A vs Books) - looking fo
  2. TDS ON PF FORM 19 WITHDRAWAL
  3. Can a virtual office in Mumbai be used for company
  4. Eway and e invoicing in condition where 4 party ar
  5. Bank balance in ITR-3
  6. INCLUDING PROFITS FROM REIT / INVIT IN SHARE TRADI
  7. Tempsens Instruments IPO GMP Allotment Listing dat
  8. Upload Type - Correction. Not showing in TDS filli
  9. Partnership tax audit query
  10. ERROR SHOWING PARTNER REMUNERATION ITR 3 TIME OF V

More recent discussions | Post

Related Topics :

Loading