Consulting

Results 1 to 3 of 3

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

  1. #1

    hi im new to VBA need some help copy and pasting with a twist.

    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.

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    CAPS LOCK ON. too hard to read
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    [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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •