PDA

View Full Version : hi im new to VBA need some help copy and pasting with a twist.



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.

SamT
04-27-2013, 02:04 PM
CAPS LOCK ON. too hard to read

cdafonseca
04-28-2013, 01:47 AM
[quote=cdafonseca] would be possible to make a macro that will
read the names from x number of cellls from one sheet
then from each name that it founds .

go into a second sheet compare and retrieve the same name like finding a duplicate but bare in mind that the names on the second sheet the names only match the first characters.


after that copy them and paste it into other cell

this is for a work in progress

just discover what a macro vba is a few weeks ago and my knowledge is very limited.


thanks to spend your precious time reading