Hi all,
I'm having a really difficult time trying to figure out how to approacha a task. I would appreciate any direction you may be able to offer. To explain, each month a new workbook is created to plug data into about different process. There are four different processes, and each process has it's own sheet in each workbook. An example of one sheet is below. I need to take the information from each of these sheets in each of these workbooks and combine it into one sheet that has only specified informaton. This sheet will need to contain the date, process #, code #, Crew, three specific rows worth of time for each sheet (specifically the rows that list 12, 20A and 29A in column B), and the comments for the cells in those rows.
Does anyone have any idea how to even get started on this? I was thinking about breaking it down into months and then combining it from the months into a master. I would like this to be as automated as possible though. Problems that I am currently encountering are how to make only the cells from the specified rows display if there is a value and how to transfer the comments into a corresponding cell below the original cell.
<tbody>
</tbody><colgroup><col><col><col><col><col span="7"></colgroup>
I'm having a really difficult time trying to figure out how to approacha a task. I would appreciate any direction you may be able to offer. To explain, each month a new workbook is created to plug data into about different process. There are four different processes, and each process has it's own sheet in each workbook. An example of one sheet is below. I need to take the information from each of these sheets in each of these workbooks and combine it into one sheet that has only specified informaton. This sheet will need to contain the date, process #, code #, Crew, three specific rows worth of time for each sheet (specifically the rows that list 12, 20A and 29A in column B), and the comments for the cells in those rows.
Does anyone have any idea how to even get started on this? I was thinking about breaking it down into months and then combining it from the months into a master. I would like this to be as automated as possible though. Problems that I am currently encountering are how to make only the cells from the specified rows display if there is a value and how to transfer the comments into a corresponding cell below the original cell.
| Enter Date Range | 4/30/14 | 4/30/14 | ||||||||
| Date | 4/1/14 | 4/1/14 | 4/1/14 | 4/2/14 | 4/2/14 | 4/2/14 | 4/2/14 | |||
| Process Order # | 3 | 41 | 45087683 | 45087683 | 45087895 | 45087895 | 45088631 | 45088338 | 45088338 | |
| Code # | 1AM80A00 | 1AM80A00 | 1A517A70 | 1A517A70 | 16132A70 | 1A844A0T | 1A844AOT | |||
| Crew | C | D | D | C | C | C | D | |||
| Changeover Counter | L21 | 1 | 21 | 1 | 1 | 1 | ||||
| Class A Changeover | 01A | 0.0 | 7.8 | |||||||
| Class B Changeover | 01B | 0.0 | 7.6 | 1.8 | ||||||
| Class C Changeover | 01C | 1.0 | 23.9 | 0.75 | 1.1 | |||||
| OP Blade Change | 2 | 0.0 | 4.2 | 0.25 | ||||||
| OP Procedure Error | 3 | 1.9 | 8.4 | |||||||
| OTHER No Operator | 4 | 0.0 | 0.0 |
<tbody>
</tbody><colgroup><col><col><col><col><col span="7"></colgroup>
