Auto-populating calendars using excel - marketing purposes

I adjusted the formulas in the calendar to not use column specific named ranges. As you'll see, the formula used is:

=IF(ISERROR(J6),"",INDEX(CalendarItems,J6,2) & " - " & INDEX(CalendarItems,J6,4) & " - " &TEXT(INDEX(CalendarItems,J6,7),"$###,###.00"))

This only uses the named range of CalendarItems, which is the entire table. Simply use the column number as shown in the formula.

The problem you were having is that you refered to a CalendarItemVendor, which did not exist.