I know his question has been asked before (many times), but I just can't seem to find the right formula/combination of formula to do what I need. I know tat I'm missing something, probably really simple, but for the life of me I can't figure it out.
I am trying to autopopulate worksheets with data contained in the first worksheet. Basically it's an annual calendar of meetings, all 12 months showing on sheet 2. I will then produce monthly sheets with further information (only pulling some information from the first sheet.
Whilst I've managed to get a straightforward formula to autopopulate a single entry, I can't get it to find the correct information to autopopulate the subsequent lines within that month!
I've attached my file for reference.
Many thanks in advance for any help!
Lynne
Bookmarks