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.