so frustrating. My calendar was working and now it not it puts REFF in the cell and I don't know why.
Please can some one help
so frustrating. My calendar was working and now it not it puts REFF in the cell and I don't know why.
Please can some one help
Please attach the .xls file, not a .zip. Thanks!
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry here you go I hope you can help I been all afternoon trying to figure it out
Your very 1st index...
INDEX(CalendarItemRoom,Q7)
looks like it is trying to find something in row 31, but you only have 30 rows?
They are all using Q7 (31) in a range that is not 31 rows long. Replace 31 with 30 (typed in) and it worked omn
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks so now I need to work on my index as they are all adding one row to many.
so it is asking for row 2 which is correct but which in fact is row number 1 in my table as the headers are row 1
I think it has something to do with the name manager
My CalendarDates are =OFFSET('Calendar Items'!$A$1,,,COUNTA('Calendar Items'!$A$1:$A$500),)
My CalendarItems(which is the whole table) =OFFSET('Calendar Items'!$A$1:Y503,,,COUNTA('Calendar Items'!$A$1:$O$500),)
when I play around with these it changes the index number.
This is my index row number =SMALL(IF(CalendarItemDates=Calendar!C$5,ROW(CalendarItemDates)),ROW(1:1))
Last edited by Wornout8; 01-30-2017 at 02:16 PM.
I have changed the formula and this calander works great you put the data in the data sheet and it comes up on the calendar. I am just working on the form to put the data in when you click on a date
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks