I have an Excel Workbook with 2 worsheets labeled 1) Medicare Hospitalized List and a second worksheet labeled 2) Hospitals.
The first worksheet includes 7 columnar fields labeled A)Patient Name, B)Entry Date, C)Hospital, D)Phone Number, E)Room Number, F)Status and G)Discharge Date.
The second worksheet has a list of all the available hospitals in the area and includes the following data: A)Number, B)Name and C)Telphone #.
I would like to know what function to use to have the first worksheet look at the second and plug in that data. Example ... The person entering the data into the first worksheet enters name, and entry date adn then looks to sheet # 2 and enters the coresponding name and number of the hospital.
How is that done? Any input would be helpful.
Thanks
Rudy
The first worksheet includes 7 columnar fields labeled A)Patient Name, B)Entry Date, C)Hospital, D)Phone Number, E)Room Number, F)Status and G)Discharge Date.
The second worksheet has a list of all the available hospitals in the area and includes the following data: A)Number, B)Name and C)Telphone #.
I would like to know what function to use to have the first worksheet look at the second and plug in that data. Example ... The person entering the data into the first worksheet enters name, and entry date adn then looks to sheet # 2 and enters the coresponding name and number of the hospital.
How is that done? Any input would be helpful.
Thanks
Rudy