+ Reply to Thread
Results 1 to 1 of 1

Copy/Paste range of cells to another worksheet based on matching criteria

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2003
    Posts
    1

    Copy/Paste range of cells to another worksheet based on matching criteria

    This is my first post, so please forgive me if I haven't provided enough information or if I've broken any rules.

    I have a macro that pulls a report into this workbook (sheet "24HR"). It is pulled every 12 hours, but needs to be transferred to the 1st worksheet ("Saturday").

    So far, I'm just copying/pasting "Days" data after that shift is done, but now I need to transfer "Nights" data after that shift is done to match it up.

    I would like to pull the data from "24HR" (D3:E6) and place it in (T9:T12), based on matching the Unit numbers of each sheet. After that, I need it to loop through each unit and put it in the right cells.

    I have tried VBA and VLookup, but I run into problems because at times, a specific unit may not have data to pull on nights, so I need to match it up.

    Thank you so much in advance. Please let me know if you need more information.

    I have attached a sample 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. Copy/Paste Range to Another Range based on Criteria
    By ExcelFinWizzard in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-13-2012, 09:35 AM
  2. Auto Copy & Paste Range Based on Criteria
    By dreicer_Jarr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2012, 04:00 PM
  3. Macro to copy a range of dates based on matching criteria
    By christopherb in forum Excel General
    Replies: 0
    Last Post: 06-10-2011, 05:39 AM
  4. VBA Code to copy a "criteria based" range of cells from worksheet A to worksheet B
    By xbaglione in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2010, 10:37 AM
  5. Copy/Paste Certain Cells matching criteria
    By dvs12c in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2009, 11:05 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