Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I move data based on a conditional column search?
I need to know whether or not it is possible to move data into other cells
based on a two column search, before I devote time. The last time I programmed in VBA was 4 years ago and have lost touch with its capabilities. Anyone? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I move data based on a conditional column search?
Yes, given the limited information, it should be possible.
You might start with looking at the Find method in xl vba help. Find the value least likely to occur, then check if the second value is there. If yes, done. If not, find the next occurance of the least likely. Bake until done. (the help example for the FINDNEXT command will help) Also, if this is a triggered action, look a Chip Pearson's page on events http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "bbaek" wrote in message ... I need to know whether or not it is possible to move data into other cells based on a two column search, before I devote time. The last time I programmed in VBA was 4 years ago and have lost touch with its capabilities. Anyone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Macro to move data to different column based on data in another co | Excel Discussion (Misc queries) | |||
Search column and move text formula | Excel Discussion (Misc queries) |