Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for anything but
I have a list from a1:a200
I want it so that if any values anywhere in that list are entered the they should be copied and pasted in the b column starting at b1. Eg if a5 = 10 and a27 = hello B1 = 10 B2 = hello any idea's -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for anything but
Try this macro :-
'----------------------------------- Sub test() Dim Arow As Long Dim Brow As Long Brow = 1 For Arow = 1 To 200 If ActiveSheet.Cells(Arow, 1).Value < "" Then ActiveSheet.Cells(Brow, 2).Value = _ ActiveSheet.Cells(Arow, 1).Value Brow = Brow + 1 End If Next End Sub '-------------------------------------- -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two search category & two search terms | Excel Discussion (Misc queries) | |||
file search or search files | Excel Discussion (Misc queries) | |||
Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
Functions (search within search result) | Excel Worksheet Functions | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions |