if you open the book you will see what I envision to have when I am done although key formulae are missing. I tried to use array formula to evaluate for cell values in column A but they would not work. I would like the top page to be the data entry page and the pages below to be where the data is evaluated for each nurse. I need to know how to search column A in the top page for a certain value (name). If that value is found all data in that row would populate to the corresponding cell on the nurse's page. Visually the book is set up how I want it to work however I need help with the formulae that would import the data from the top sheet.naughty list form example specific nurse.xlsx
Bookmarks