Help linking calendar to spreadsheet

Hi, I'm a newbie that needs some help please!

I work in ad sales and need to create calendars in month view that show the client what days they have ads and the cost of that ad/per day. I need an Excel spreadsheet by month that will pull data from the calendar so I can add totals. I am currently creating calendars in Word and then recreating in an Excel spreadsheet. Any suggestions how I can make this more efficient? Thanks!

How many entries are you likely to have per day? I have an Excel calendar file that enables the user to enter events and dates in any order on one sheet, and on the calendar sheet the events are automatically shown on the appropriate day with up to 7 events per day. The month and year to view can be selected from two drop-downs.

Does this sound suitable to you?

Pete

Hi there,
This is my first post! I came across your post on linking calendars to a spreadsheet and this look exactly like what I am looking for. I have a spreadsheet that has target closure dates on it and I would like to display this information on a calendar. I hope it isn't too hard!

Marzy

Well, the first poster didn't get back to me, but I've attached the file that I referred to above. You can list the events in any order on the Activities sheet, and then use the drop-downs in K3 and K4 of the Calendar sheet to select the month and year that you are interested in. The calendar will adjust automatically. No macros - purely formula-driven.

Hope this helps.

Pete

Pete,
Wow, this is exactly what I was looking for. Perfect!!

Thanks Pete.

Marzy.

Glad to hear that, Marzy - thanks for feeding back.

Pete

Hi Pete,

I was searching for a similar solution and came across this. Can you provide me with additional information? Does revising or deleting the ref column cause an issue? Also, is there a way to add another column such as staff responsible to the spreadsheet and have it appear on the calendar?

Thanks,
Susan