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 February 10th, 2011, 02:19 PM
Registered User
 
Join Date: Nov 2009
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default populating an excel calendar with excel source data

Hello,

I have two spreadsheets in one workbook. One spreadsheet is a calendar in which I want to populate with each events from the second spreadsheet, the data source.
so far this formula works =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) but when i drag the formula through the range of the calendar date (which is 15 cells), i get false if data is not a match as in the example below. the (1) Is the date (2/1/2011)

1 10109 - Bradford - Deva & Assoc
FALSE
FALSE
FALSE

This is not what I want,(though this is what I told excel to do), I would like to do is, if the data is not a match then skip the unmatches until you find the next match and populate the data with the correct date.

What am I missing???

Last edited by kmclean; February 10th, 2011 at 02:23 PM..





Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting excel data to Access using excel VBA ShaileshShinde VB Databases Basics 1 April 26th, 2006 07:57 AM
Populating Combo with values from Excel r_ganesh76 Excel VBA 2 February 4th, 2005 06:53 AM
Pivot tables in Excel with cubes as data source boson SQL Server 2000 2 January 28th, 2005 07:16 AM
Excel as Data Source bmains ADO.NET 2 February 5th, 2004 04:42 PM
Excel in win 2000 to excel winxp (excel 2002) Max Excel VBA 3 August 28th, 2003 04:44 AM





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