Previous Topic Next Topic

Copy complete sheet in excel with condition of a word

Closed
shugi100 Posts 1 Registration date Thursday 5 September 2013 Status Member Last seen 5 September 2013 - 5 Sep 2013 à 15:34
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Sep 2013 à 01:09
i want to copy a complete sheet in excel,
but only the data with specific word in one of the columns.
for example :
number name rate
1 dan 90
2 dan 100
3 tal 60
4 dan 30
5 roy 50
6 dan 100

copy entire sheet if the name "dan" in column "name".
result :
number name rate
1 dan 90
2 dan 100
4 dan 30
6 dan 100
Related:

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Sep 2013 à 01:09
autofilter data according to column B criteria being "Dan" and copy filtered data to another sheet.
remove filter from the data sheet.
this can be done manually easily even if data is more number of rows