Hi all,
I have what might be a very complicated 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. I want to add a button (for the basic user) on a *new* spreadsheet/report that will act like this code I have used for another report (go to to the specified 'unprocessed' folder, open the Word forms, populate the spreadsheet with the form fields, close the document and transfer it to the specified 'processed' 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)
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
Bookmarks