Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 7th, 2006, 04:05 PM
Authorized User
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default create calendar from spreadsheet data

I'm not sure if there is an easy way to do this, but I have a spreadsheet with dates, times, events and locations, etc. listed and was wondering if there was an easy way to create a calendar from the information... ie parse the data and fill in the calendar blocks with the event information according the date field of the spreadsheet. Hope that makes sense.
Old February 10th, 2011, 01:53 PM
Registered User
Join Date: Nov 2009
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default populating a spreadsheet calendar with data

I have a similar question and was wandering if you got help. I have two spreadsheet in which one is a calendar that I created. In the other spreadsheet is my source data in which I am trying to populate the calendar spreadsheet with events from the source data spreadsheet. I used =IF(Calendar!$K$23='2009 (2)'!U3,INDEX('2009 (2)'!A3,MATCH('2009 (2)'!U:U,'2009 (2)'!A3,'2009 (2)'!U3))&" - "&'2009 (2)'!C3&" - "&'2009 (2)'!R3)

to get the data formatted as I want it displayed on the calendar. the problems is that the data is populating in the wrong cells. how do i tell excel to only populate the fields with the source date that is a match to to date?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Table data into an Excel SpreadSheet hewstone999 Access VBA 0 March 3rd, 2008 07:00 AM
need help to create my country calendar dimension dbayona SQL Server 2000 1 July 4th, 2007 12:54 AM
Pull up or Create Record on Calendar Click Maverick10gk Pro VB Databases 10 April 26th, 2007 02:23 PM
How to create event in Calendar smartacrobat ASP.NET 2.0 Basics 0 January 4th, 2007 02:54 AM
Importing spreadsheet data with more control tencelos Access VBA 2 September 1st, 2006 10:30 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.