+ Reply to Thread
Results 1 to 2 of 2

Macro to pull cellls based on text into another worksheet

  1. #1
    Forum Contributor
    Join Date
    07-15-2011
    Location
    Whitby, Canada
    MS-Off Ver
    Excel 2010
    Posts
    121

    Macro to pull cellls based on text into another worksheet

    *This is a repeat thread, hoping for an answer...*

    Hi all,

    I have an idea I would like to implement for reporting purposes - to be used by a beginner Excel user (not me).
    I have shift reports that are submitted 2x daily (sample attached). What I want to do is to pull a report based on the criteria outlined below.
    The individual shift reports are saved in a specific folder.

    For the purpose of this macro, I only want to copy cells if the shift report contains any shift-codes containing "AC" or "APC" (highlighted in yellow in my attached sample). If any of the cells in the range A3:F26 cell contains that criteria then:

    Copy the cell to the right (containing the empoyee name) of the code into one colum, then copy the *required* cell (containg the code with "AC" or "APC" in it) into the next column - also:

    Copy the cell E20 (showing the date) into another column (repeating)
    Copy the cell A1 (showing the shift ID) into another column (repeating)
    Copy the cell E18 (showing the shift hours) into another column (repeating)

    I want to copy values only - not formulas

    I have included another tab in the workbook to show how I would like the report to turn out - In the end, I need to use the report to tell me the number of hours each employee has for specific shift codes each month by filtering or using another macro - whatever, first things first!
    I know this is asking a lot, but sure could use your expertise! TIA
    Last edited by Greed; 02-17-2012 at 10:56 AM. Reason: Close

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Macro to pull cellls based on text into another worksheet

    Hi Greed,

    Instead of creating a new thread for the same issue, its advisable that you bump the previous one for a response. Since you have already opened this one, you can close the other thread or mark as solved.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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