By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,485 Members | 1,804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,485 IT Pros & Developers. It's quick & easy.

Pulling Data from Sheet into Calendar

P: 1
Hello there,

I need help. I am NOT an excel wizzard and have a complex issue I need help with. :(

I have an excel data sheet where I enter campaign ad data. Main fields in columns are:

a). Type Ad (options: Special Offer,
House Ad, Paid Ad)
b). Ad Slot (Slot 1, Slot 2, Slot 3, Slot 4)
c). Start Date, End Date (dates are sometimes duplicates and overlap)
d). Offer Details (Campaign Name)

I want to pull in the "offer details" into a calendar view in the next sheet based on the calendar date. So basically populate the calendar with all the ads running on that date.

I have tried lookups but since there are date range duplicates and no specific id I can't seem to get it right. Can someone help? I have a spreadsheet available to share if any of this is unclear.

Thanks much in advance.
AC
Dec 9 '11 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,709
Are there specific dates in column C or are they strings that can represent date ranges etc?
Dec 10 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.