Previous Topic Next Topic

Linking Excel Data to Excel-Based Calendar

Closed
mcamp63 Posts 1 Registration date Monday February 8, 2010 Status Member Last seen February 8, 2010 - Feb 8, 2010 at 07:42 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2010 at 09:37 AM
Hello,

Okay, here I go. I have a workbook which contains a tab (CalendarData) with information as follows:

Column A - Name
Column B - Apt #
Column C - Initial Follow-Up
Column D - 30-Day
Column E - 90-Day
Column F - 180-Day

The calendar tab is simply called 'Calendar'

I need to have the information in Columns A & B populate the dates on the calendar which coincide with Columns C, D, E, and F.

Can anyone help me with this?
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2010 at 09:37 AM
One of most easy way of doing it would be if you can add a column to CalendarData and use the formula

=A1 & "|" & B1 and fill it to the last row (lets say you add in column C)

Then in calendar you can use VLOOKUP as

=vlookup(a1 & "|" & b1, CalendarData !C:G, 2,FALSE) to get the Initial Follow-Up and so on
5

Similar discussions

Google Calendar icon displays wrong date
thegunz -
thegunz -

5 responses
need to find formula to say happy birthday
whitedevil65 -
rizvisa1 -

4 responses
Auto notify or mail when Excel sheet updated.
Satya -
cdb2013 -

20 responses
macro to compare two excel sheets
annajins -
Aks -

6 responses
Excel Golf Skins Sheet
agw2010 -
agw2010 -

2 responses
Automatically update master worksheet from other worksheets
Saktivel -
vcoolio -

18 responses