ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copying from one SHEET to onother with the condition... (https://www.excelbanter.com/excel-programming/312275-copying-one-sheet-onother-condition.html)

mlradak

Copying from one SHEET to onother with the condition...
 

Getting a NEW Sheet with data from one sheet with the CONDITION....

OLD SHEET
----------------
1 test 4 5 m
2 mladen 3 6 h
3 mladen 6 6 m
4 nikola 6 2 h
5 nikola 2 1 h
6 test 5 3 r
7 test 2 5 e
8 mladen 1 6 m

CONDITION = m
-------------

NEW SHEET
----------------
1 test 4 5 m
3 mladen 6 6 m
8 mladen 1 6 m


How can I do this?
Please HELP!
Mladen


--
mlradak
------------------------------------------------------------------------
mlradak's Profile: http://www.excelforum.com/member.php...o&userid=14951
View this thread: http://www.excelforum.com/showthread...hreadid=265833


Ron de Bruin

Copying from one SHEET to onother with the condition...
 
See possible answer in worksheet functions

--
Regards Ron de Bruin
http://www.rondebruin.nl


"mlradak" wrote in message ...

Getting a NEW Sheet with data from one sheet with the CONDITION....

OLD SHEET
----------------
1 test 4 5 m
2 mladen 3 6 h
3 mladen 6 6 m
4 nikola 6 2 h
5 nikola 2 1 h
6 test 5 3 r
7 test 2 5 e
8 mladen 1 6 m

CONDITION = m
-------------

NEW SHEET
----------------
1 test 4 5 m
3 mladen 6 6 m
8 mladen 1 6 m


How can I do this?
Please HELP!
Mladen


--
mlradak
------------------------------------------------------------------------
mlradak's Profile: http://www.excelforum.com/member.php...o&userid=14951
View this thread: http://www.excelforum.com/showthread...hreadid=265833





All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com