Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking Column for matching value
I have a excel file with 2 sheets, The 1st sheet has information that is
imported. the 2nd sheet pulls certain information from the 1st. (I used macro record to do that.) I what to add some kind of code to the macro so when it gets to the end of the recorded macro is goes back to the 1st sheet and compares a cell (B2) to the rest of the cells in that Column(B) if it finds a match then it goes to another cell in that Row(C) and copys it to a certain cell(C9) in the 2nd sheet. repeats this again, but the next one it finds it would copy to cell(E9) in sheet 2. If it doesnt find a match it just contiuse on with the macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Column Entries | Excel Worksheet Functions | |||
Checking a column of values against another one | Charts and Charting in Excel | |||
Checking a cell's (Row,Column) | Excel Programming | |||
checking celll in column | New Users to Excel | |||
checking value in column | Excel Programming |