Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-24-2023, 12:17 PM
jbro110 jbro110 is offline Pulling data from a spreadsheet to populate a color coded excel calendar Mac OS X Pulling data from a spreadsheet to populate a color coded excel calendar Office 2016 for Mac
Novice
Pulling data from a spreadsheet to populate a color coded excel calendar
 
Join Date: Oct 2023
Posts: 1
jbro110 is on a distinguished road
Default Pulling data from a spreadsheet to populate a color coded excel calendar

Hello Excel Pros!

I need some help! I have an existing spreadsheet with a lot of information in it that I would like to be able to populate in a weekday calendar with color coding.

The information in the sheet is about classes taught/held. Each class has a start time, end time, class code, and there are multiple entries, each for individual students. I would like to take this data and populate it visually in an Excel calendar.

For example, if 7 people attended a class from 12:00pm-1:00pm I would like it to read the name of the class, # of people attended, teacher name, and the class code in the color coded "block" of time @ the calendar. If this is done correctly, I should be able to see what classes were held during the week in the calendar visually

I have an existing calendar with all the classes that are supposed to be held during the week. I would like to use the data described above to build a calendar with all the classes that were actually held to make the comparison. I also would like to be able to see all the classes that the teachers teach individually, and all of the classes that a student attended individually.



I am happy to answer any questions about what I am looking for if there is any confusion. If you can make this happen, you will make my day!!! Thank you so much Excel community!!! Look forward to hearing your expert advice! Thanks, Joel.
Reply With Quote
  #2  
Old 10-24-2023, 11:30 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Pulling data from a spreadsheet to populate a color coded excel calendar Windows 10 Pulling data from a spreadsheet to populate a color coded excel calendar Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
please post a sample sheet ( no pictures please) with some data and manually mocked up results . Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
excel calendar, interactive calendar, visual data

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting color coded cells into numbers (Excel 2007, Windows Vista) angExcelentflea Excel Programming 1 02-10-2021 06:24 AM
Auto populate form (data from excel) in Word based on drop down list selection (data from excel) wvlls Word VBA 1 03-22-2019 02:29 PM
Pulling data from a spreadsheet to populate a color coded excel calendar Pulling Data From Excel ptmuldoon Word VBA 7 03-19-2016 03:28 PM
Import Excel spreadsheet calendar data into Outlook 2010 davesp Outlook 0 09-30-2013 09:26 AM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft