Results 1 to 3 of 3

Thread: Picking and copying data from another sheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2016
    Posts
    151
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Picking and copying data from another sheet

    Please can someone help with a formula or VBA script.


    I have one workbook (payslip sort) that contains several sheets (one sheet per person that contains a breakdown of their pay) - I have another workbook (payslip macro) that contains a list of names in column A and next to their names in Column B their email address.


    Is it possible to have a code that looks up the name on each sheet in (payslip sort) which can be find in A2 (see below example) - and search for that name in the other worksheet (payslip macro) (the list at present located in sheet2 - however this can be moved if that is a problem or even added to the main worksheet) - and copy the email address to i1 in payslip sort.

    Payslip sort
    Name P/E Date Shift Company Location Units Pay Rate Total Pay zak@bbc.com
    Zak Mon 29 Jul 2019 NA - Day Constance xxxxxxxxxxxxxxxxxxxxxxxxxx .50 9.00 4.50
    Zak Mon 29 Jul 2019 NA - Day Dermott xxxxxxxxxxxxxxxxxxxxxxxxxx 45.00 9.00 405.00
    Zak Mon 29 Jul 2019 NA - Day Kelly xxxxxxxxxxxxxxxxxxxxxxxxxx 1.00 9.00 9.00


    Payslip macro (sheet2)

  2. #2
    Board Regular
    Join Date
    Aug 2003
    Location
    England
    Posts
    5,615
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Picking and copying data from another sheet

    Hello,

    Isn't it just a case of having a VLOOKUP?

    i.e. = VLOOKUP(A2,(payslip macro, sheet 2 cols A & B),2,0)

    you will need to change (payslip macro, sheet 2 cols A & B) to the actual workbook range.
    Last edited by onlyadrafter; Aug 27th, 2019 at 09:28 AM.
    -------------------------
    Hope this is helpful.
    -------------------------

    Have been away from the forum for quite a while, but am now back.

  3. #3
    Board Regular
    Join Date
    May 2016
    Posts
    151
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Picking and copying data from another sheet

    Thank you for your help - I will give this a try

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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