Ok here's what I am trying to accomplish.
I have a workbook with 3 sheets.
Sheet 1 is like this:
Sheet 2 is client data and I would like to input into a cell the Flight_No from Sheet 1 and have the next cells auto fill the info for Airline_Name, Flight_Time and City. This will done for arrivals and departures.
I've seen some formulas and code to auto fill in cells but nothing that quite matches what I'm trying to accomplish. Is this to big of a task for Excel?
I've attached the file for anyone that wants to see what it's like so far.
Bookmarks