Hi,
Thanks for helping. I work for a preschool and I am trying to create a master sheet with all our childrens information including attendance days and rooms, and link to other workbooks for lists, day sheets etc. I would like all sheets to have autofill, so when a child changes days or rooms I don't have to update 5 different workbooks. I have been using if, and if/and functions mostly to success. This one has me stumped though.
I need a workbook that shows a room list of each child attending per day.
My formula is =IF(AND([master sheet 2013.xlsx]Sheet1'!C2="M",[master sheet 2013.xlsx]Sheet1'!K2="Dolphin"),[master sheet 2013.xlsx]Sheet1'!A2)
I have shortened this from the actual formula, mine includes D2, E2 & F2 columns also.
M = Monday, and the room is Dolphin. This is giving me a result with some False answers - being children that aren't coming on Monday or in Dolphin Room. I am then Filtering out false data and copying to the Monday column - which is time consuming.
Is there a way to link the data from my Monday column to my worksheet to skip over False data, to save on the filtering and copying, and so it can update with Autofill?
I have attached examples of 2 of the workbooks. Thanks, Sarah
master sheet template.xlsxchild list template.xls
Bookmarks