Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 7th, 2006, 05:05 PM
Authorized User
 
Join Date: Dec 2004
Location: Honolulu, HI, USA.
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.
Reply With Quote
  #2 (permalink)  
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?
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 01:54 AM
Pull up or Create Record on Calendar Click Maverick10gk Pro VB Databases 10 April 26th, 2007 03: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 11:30 AM



All times are GMT -4. The time now is 04:26 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.