http://www.excelforum.com/excel-form...ml#post4439479
Using the solved request above, I've replicated the calendar but cannot replicate the auto-filling of data (in the case of the above, car names); I'm looking to automatically populate a calendar based on the class I am teaching, in the period I am teaching, and on the day this will happen.
I've attached the document if any one is able to help.
Thanks in advance.
Richard
Try this in L11:
=INDEX(Schedule!$B$1:$G$233,MATCH('Monthly Overview'!M9,Schedule!A1:$A$233,0),MATCH('Monthly Overview'!J5,Schedule!$B$1:$F$1,0))
Hopefully it will get you started.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Many thanks for this AliGW; I'm quite pleased that the help you provided was simply one formula as it meant I then had to add it to other cells myself, thus learning. One further question:
Some cells show #N/A due to the 'date (M9 in the previously attached example)' cell not being filled in; is there a way to avoid this?
Many thanks,
Richard
Yes, there is:
=IFERROR(INDEX(Schedule!$B$1:$G$233,MATCH('Monthly Overview'!M9,Schedule!A1:$A$233,0),MATCH('Monthly Overview'!J5,Schedule!$B$1:$F$1,0)),"")
I am glad you worked it out - yes, you will have learnt from this exercise. It's how I've learnt what I know and it's much more satisfying than getting someone else to do it all for you.
Would I enter this formula into the cell instead of the previous formula? I have spent a lot of time recently learning stuff with excel with the hope of making my life slightly easier during the next academic year
Thanks, again.
Yes - you just add this round each formula:
IFERROR(...),"")
It traps the error message and returns a blank cell instead.
Are you a teacher?
Would IFERROR work for all formulas if I wanted a blank cell instead of #N/A? I am indeed
Yes, it will work for all formulae.
I am a teacher if MFL.
Brilliant! RE/Philosophy, here
You're welcome! I'm trying not to think about the new school year just yet - as a HoD, I'll be back at work to all intents and purposes from mid-August when results start coming in.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks