chrono2483
Board Regular
- Joined
- Aug 23, 2014
- Messages
- 164
- Office Version
- 2016
Hello,
I have 2 sheets within a workbook, RawData! and View!. I want to be able to paste raw data into the RawData! sheet, and have specific data be references within certain headings on the View! sheet. My attempt to create a visual of what I want to do is below:
RawData! sheet: The data can be shorter or longer, based on the raw data pulled - as such, once raw data is pasted, cell location may vary.
<tbody>
</tbody>
The View! sheet before the raw data is pasted will look like this:
<tbody>
</tbody>
Once the raw data is pasted into RawData! sheet, I want to be able to find and reference the Date, Agent Name, Scheduled Start Time and Actual Start Time, to look like this:
<tbody>
</tbody>
Is this possible, and how? VBA script? Formulas within View! sheet? Please help
Thank you everyone in advance!
<tbody>
</tbody>
I have 2 sheets within a workbook, RawData! and View!. I want to be able to paste raw data into the RawData! sheet, and have specific data be references within certain headings on the View! sheet. My attempt to create a visual of what I want to do is below:
RawData! sheet: The data can be shorter or longer, based on the raw data pulled - as such, once raw data is pasted, cell location may vary.
| A | B | C | D | E | F | |
| 1 | Note:Raw Data | |||||
| 2 | Date: 2/3/15 - 2/3/15 | |||||
| 3 | Agent: Sawyer, Tom | |||||
| 4 | Date: 2/3/15 | |||||
| 5 | Scheduled | Actual | ||||
| 6 | From | To | Duration | From | To | Duration |
| 7 | 10:45 AM | 12:15 PM | 01:30 | --:-- | --:-- | --:-- |
| 8 | 12:15 PM | 12:30 PM | 00:15 | --:-- | --:-- | --:-- |
| 9 | 12:30 PM | 1:40 PM | 01:10 | --:-- | --:-- | --:-- |
| 10 | --:-- | --:-- | --:-- | 1:41 PM | 2:55 PM | 01:14 |
| 11 | 2:00 PM | 2:30 PM | 00:30 | --:-- | --:-- | --:-- |
| 12 | 3:20 PM | 4:00 PM | 00:40 | --:-- | --:-- | --:-- |
| 13 | 4:00 PM | 4:15 PM | 00:15 | --:-- | --:-- | --:-- |
| 14 | --:-- | --:-- | --:-- | 4:06 PM | 4:21 PM | 00:15 |
| 15 | 4:15 PM | 6:45 PM | 02:30 | --:-- | --:-- | --:-- |
| 16 | --:-- | --:-- | --:-- | 5:31 PM | 6:15 PM | 00:44 |
| 17 | Agent: Pan, Peter | |||||
| 18 | Date: 2/3/15 | |||||
| 19 | Scheduled | Actual | ||||
| 20 | From | To | Duration | From | To | Duration |
| 21 | --:-- | --:-- | --:-- | 9:00 AM | 9:02 AM | 00:02 |
| 22 | 9:00 AM | 10:45 AM | 01:45 | --:-- | --:-- | --:-- |
| 23 | 10:45 AM | 11:00 AM | 00:15 | --:-- | --:-- | --:-- |
| 24 | 11:00 AM | 12:45 PM | 01:45 | --:-- | --:-- | --:-- |
| 25 | --:-- | --:-- | --:-- | 12:04 PM | 12:18 PM | 00:14 |
| 26 | --:-- | --:-- | --:-- | 12:18 PM | 12:19 PM | 00:01 |
| 27 | --:-- | --:-- | --:-- | 12:45 PM | 12:46 PM | 00:01 |
| 28 | 12:45 PM | 5:15 PM | 04:30 | 12:46 PM | 5:15 PM | 04:29 |
| 29 | 5:15 PM | 7:00 PM | 01:45 | --:-- | --:-- | --:-- |
| 30 | 7:00 PM | 7:15 PM | 00:15 | --:-- | --:-- | --:-- |
| 31 | 7:15 PM | 9:00 PM | 01:45 | --:-- | --:-- | --:-- |
| 32 | --:-- | --:-- | --:-- | 8:26 PM | 8:40 PM | 00:14 |
| 33 | Agent: Simpson, Bart | |||||
| 34 | Date: 2/1/15 | |||||
| 35 | Scheduled | Actual | ||||
| 36 | From | To | Duration | From | To | Duration |
| 37 | 11:30 AM | 1:00 PM | 01:30 | --:-- | --:-- | --:-- |
| 38 | 1:00 PM | 1:15 PM | 00:15 | --:-- | --:-- | --:-- |
| 39 | 1:15 PM | 2:00 PM | 00:45 | --:-- | --:-- | --:-- |
| 40 | 2:00 PM | 2:30 PM | 00:30 | --:-- | --:-- | --:-- |
| 41 | 2:30 PM | 2:45 PM | 00:15 | --:-- | --:-- | --:-- |
| 42 | --:-- | --:-- | --:-- | 2:31 PM | 2:45 PM | 00:14 |
| 43 | 2:45 PM | 3:15 PM | 00:30 | --:-- | --:-- | --:-- |
| 44 | --:-- | --:-- | --:-- | 3:03 PM | 3:55 PM | 00:52 |
| 45 | 3:15 PM | 4:15 PM | 01:00 | --:-- | --:-- | --:-- |
| 46 | --:-- | --:-- | --:-- | 4:03 PM | 4:09 PM | 00:06 |
| 47 | 4:15 PM | 5:00 PM | 00:45 | --:-- | --:-- | --:-- |
| 48 | --:-- | --:-- | --:-- | 4:33 PM | 5:02 PM | 00:29 |
| 49 | 5:00 PM | 5:15 PM | 00:15 | --:-- | --:-- | --:-- |
| 50 | 5:15 PM | 7:30 PM | 02:15 | --:-- | --:-- | --:-- |
| 51 | --:-- | --:-- | --:-- | 5:33 PM | 6:01 PM | 00:28 |
| 52 | --:-- | --:-- | --:-- | 6:01 PM | 6:02 PM | 00:01 |
| 53 | --:-- | --:-- | --:-- | 6:25 PM | 6:40 PM | 00:15 |
| 54 | Agent: Simpson, Homer | |||||
| 55 | Date: 1/31/15 | |||||
| 56 | Scheduled | Actual | ||||
| 57 | From | To | Duration | From | To | Duration |
| 58 | 5:45 PM | 5:53 PM | 00:08 | 5:45 PM | 5:53 PM | 00:08 |
| 59 | --:-- | --:-- | --:-- | 5:53 PM | 5:58 PM | 00:05 |
| 60 | 5:53 PM | 7:00 PM | 01:07 | --:-- | --:-- | --:-- |
| 61 | 7:00 PM | 7:15 PM | 00:15 | --:-- | --:-- | --:-- |
| 62 | 7:15 PM | 9:45 PM | 02:30 | --:-- | --:-- | --:-- |
| 63 | --:-- | --:-- | --:-- | 7:43 PM | 7:57 PM | 00:14 |
| 64 | --:-- | --:-- | --:-- | 7:57 PM | 7:58 PM | 00:01 |
<tbody>
</tbody>
The View! sheet before the raw data is pasted will look like this:
| A | B | D | E | |
| 1 | Date | Agent Name | Scheduled Start Time | Actual Start Time |
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 | ||||
| 13 |
<tbody>
</tbody>
Once the raw data is pasted into RawData! sheet, I want to be able to find and reference the Date, Agent Name, Scheduled Start Time and Actual Start Time, to look like this:
| A | B | D | E | |
| 1 | Date | Agent Name | Scheduled Start Time | Actual Start Time |
| 2 | 02-03-15 | Sawyer, Tom | 10:45 AM | --:-- |
| 3 | ||||
| 4 | ||||
| 5 | 02-03-15 | Pan, Peter | 9:00 AM | 9:00 AM |
| 6 | ||||
| 7 | ||||
| 8 | 02-01-15 | Simpson, Bart | 11:30 AM | --:-- |
| 9 | ||||
| 10 | ||||
| 11 | 1/31/15 | Simpson, Homer | 5:45 PM | 5:45 PM |
| 12 | ||||
| 13 |
<tbody>
</tbody>
Is this possible, and how? VBA script? Formulas within View! sheet? Please help
Thank you everyone in advance!
<tbody>
</tbody>
