# Analysis Sheet

#### cegriffin

##### New Member
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.

 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>

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
1
Views
86
Replies
7
Views
397
Replies
0
Views
137
Replies
14
Views
386
Replies
12
Views
400

1,207,091
Messages
6,076,522
Members
446,212
Latest member
KJAYPAL200

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back