+ Reply to Thread
Results 1 to 6 of 6

Copy data from one sheet to another based on a certain criteria

  1. #1
    Forum Contributor
    Join Date
    01-13-2016
    Location
    Sheffield, England
    MS-Off Ver
    2016
    Posts
    216

    Copy data from one sheet to another based on a certain criteria

    Hi,

    I input hours worked on a daily basis in a sheet called 'Fire Register'.
    I want to take the amount of hours worked daily and transfer to another sheet based on the employees clock number.
    The employees clock number is 'Fire Register' column D. If that number corresponds with the number in 'Stafforce Sheet' column A, I need the following info transferring:- The employees name and surname which would be in columns B & C in 'Fire Register', these would be put in to columns B & C in the 'Stafforce Sheet'. Then I need the hours transferring which would be in columns G,I,K,M,O,Q & S of the 'Fire Register'. These would be transferred to 'Stafforce Sheet' columns D,E,F,G,H,I & J.
    I am assuming this would be a VLOOKUP sort of equation which I am not to familiar with.
    Hope this makes sense and someone can help.
    this is a link to my workbook https://www.dropbox.com/s/d60ozbk1yy...2023.xlsx?dl=0

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Copy data from one sheet to another based on a certain criteria

    Hi,
    A VLOOKUP will only return a value to a single cell.

    Have you checked out the Advanced Data Filter Functionality?

    Please upload the workbook to this forum. Many of us prefer not to visit sites of unknown provenance.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    01-13-2016
    Location
    Sheffield, England
    MS-Off Ver
    2016
    Posts
    216

    Re: Copy data from one sheet to another based on a certain criteria

    Hi Richard,
    How would I go about upload the workbook to this forum?

  4. #4
    Forum Contributor
    Join Date
    01-13-2016
    Location
    Sheffield, England
    MS-Off Ver
    2016
    Posts
    216

    Re: Copy data from one sheet to another based on a certain criteria

    Capture.JPGCapture1.JPG
    this is a screen shot of what I mean. hope this helps.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Copy data from one sheet to another based on a certain criteria

    Hi,

    See the FAQ here...

  6. #6
    Forum Contributor
    Join Date
    01-13-2016
    Location
    Sheffield, England
    MS-Off Ver
    2016
    Posts
    216

    Re: Copy data from one sheet to another based on a certain criteria

    Hope this has attached the file
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-23-2016, 01:16 PM
  2. [SOLVED] Consolidated Summary Sheet - Copy data from one sheet to other based on criteria
    By sabha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2015, 03:29 AM
  3. VBA Copy data based on set criteria into new sheet
    By indik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2015, 11:58 AM
  4. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  5. Copy data from one sheet into another based on some criteria without using VB
    By fouzia in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-29-2012, 10:20 AM
  6. Replies: 4
    Last Post: 07-24-2012, 07:09 AM
  7. Copy data from a sheet to other based on a criteria
    By arun88aries in forum Excel General
    Replies: 5
    Last Post: 02-22-2011, 06:13 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1