My work uses sharepoint to create schedules, but the sharepoint interface is sometimes buggy and requires an internet connection to do work. We've created an excel spreadsheet that is editable offline, and that uses a formatted worksheet for the user to enter data. This then reorganize cells to make it conducive to copying and pasting into sharepoint directly. Our user entry worksheet has a timeline area at the top, and then several rows of information that are data entry for each event that is displayed on the timeline, one event per row. Each event has an event number that is listed in the data entry section, and a series of takeoff and land times. What I'd like to do is have the user enter the event number in the timeline area, and then have it find the event data and use conditional formatting to fill in cells based on whether or not the times are between takeoffs and landings. We have a timeline header area with times listed that can be used for comparison. The user won't want to display every event, so he needs to be able to pick which event to display. The table is essentially formatted like below, with an event # listed on the left below the timeline area, and several rows of takeoff/landing times to the right of it. I know vlookup won't work, but I can't figure out what to do.
<tbody>
</tbody>
| 0930 | 1000 | 1030 | 1100 | 1130 | 1200 | 1230 | 100 | ||
| # | XXXX | ||||||||
| # | XXXX | XXXX | |||||||
| event | name | 1st | 0900 | 0945 | |||||
| number# | 2nd | 1045 | 1130 | ||||||
| 3rd | |||||||||
| 4th | |||||||||
| event | name | 1st | 1000 | 1100 | |||||
| number# | 2nd | ||||||||
| 3rd | |||||||||
| 4th | |||||||||
<tbody>
</tbody>
