cdafonseca
04-27-2013, 11:45 AM
i NEED A MACRO THAT WILL COPY
THE NAMES FROM MY LIST NAMES AND PASTE PASTE IT ON A7:A19.
BUT THE MACRO WOULD HAVE TO LOOK FIRST ON CELLS A42:B47, A49:B52 FROM (sHEET NAME1)
AND EDENTIFY EACH CELL WITH DATA, IGNORING BLANK CELLS THEN GO TO (SHEET2)(LIST) FIND THE SAME DATA BASED ON THE FIRST CHARACTERS,COPY AND PASTE IN (SHEET NAME2 ) CELLS A7:A19
any help greatly appreciated.
THE NAMES FROM MY LIST NAMES AND PASTE PASTE IT ON A7:A19.
BUT THE MACRO WOULD HAVE TO LOOK FIRST ON CELLS A42:B47, A49:B52 FROM (sHEET NAME1)
AND EDENTIFY EACH CELL WITH DATA, IGNORING BLANK CELLS THEN GO TO (SHEET2)(LIST) FIND THE SAME DATA BASED ON THE FIRST CHARACTERS,COPY AND PASTE IN (SHEET NAME2 ) CELLS A7:A19
any help greatly appreciated.