| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying all rows that have the right requirements!
Hello. I need a loop that checks all rows in a sheet if a cell contains a specific input and then copys the row to another worksheet. How do I do that the simpliest way? /Anders -- a94andwi ------------------------------------------------------------------------ a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077 View this thread: http://www.excelforum.com/showthread...hreadid=520057 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying all rows that have the right requirements!
Hi Anders,
Look at the possibility of using Excel's built in Advanced Filter feature. If you are not familiar with this feature, see Debra Dalgleish's tutorial at: http://www.contextures.com/xladvfilter01.html If you need to automate the process, turn on the macro recorder while you perform the required steps manually. The resultant code may be edited to provide more general application. If you expreience ant problems with such editing, post back with details. --- Regards, Norman "a94andwi" wrote in message ... Hello. I need a loop that checks all rows in a sheet if a cell contains a specific input and then copys the row to another worksheet. How do I do that the simpliest way? /Anders -- a94andwi ------------------------------------------------------------------------ a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077 View this thread: http://www.excelforum.com/showthread...hreadid=520057 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying all rows that have the right requirements!
For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row
If Cells(i,"A").Value = "somevalue" Then j=j+1 Rows(i).Copy Worksheets("Sheet2").Range("A" & j) End If Next i -- HTH Bob Phillips (remove nothere from email address if mailing direct) "a94andwi" wrote in message ... Hello. I need a loop that checks all rows in a sheet if a cell contains a specific input and then copys the row to another worksheet. How do I do that the simpliest way? /Anders -- a94andwi ------------------------------------------------------------------------ a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077 View this thread: http://www.excelforum.com/showthread...hreadid=520057 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying all rows that have the right requirements!
Hi a94andwi
One way http://www.rondebruin.nl/copy5.htm Or use EasyFilter http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "a94andwi" wrote in message ... Hello. I need a loop that checks all rows in a sheet if a cell contains a specific input and then copys the row to another worksheet. How do I do that the simpliest way? /Anders -- a94andwi ------------------------------------------------------------------------ a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077 View this thread: http://www.excelforum.com/showthread...hreadid=520057 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
| Material Requirements Plan (MRP) and Capacity Requirements Plan (C | Excel Worksheet Functions | |||
| Material Requirements Planning-MRP/Capacity Requirements Planning- | Excel Discussion (Misc queries) | |||
| Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
| If statement with two requirements | Excel Worksheet Functions | |||
![a94andwi[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
