Challenge - How do you copy data in to a filtered list in Excel
by using past special options
Gobish Gopalakrishnan (Financial Analyst) (276 Points)
09 June 2011
Gokulananda Sahu
(ACA ACS ACMA ACMA CGMA)
(22 Points)
Replied 02 August 2011
Use "select visible cell" icon and copy the filtered data.
CA GIRISH
(Chartered Accountant)
(1796 Points)
Replied 02 August 2011
Acrually its not achallenge its tutorial
Ateeq
(CA - Final)
(218 Points)
Replied 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.
Exshail
(Software)
(1576 Points)
Replied 15 October 2011
Before copy & paste to filtered data make sure that the data is properly sorted.