Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > PowerPoint

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-21-2014, 05:11 AM
anhnha anhnha is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 9
anhnha is on a distinguished road
Default Create calendar in Powerpoint 2010

Could you please tell me how to make a calendar in Powerpoint 2010 like the one in slide #10 below?


It is really great.
Thank you very much.

http://www2.siit.tu.ac.th/prapun/tcs...-%20slides.pdf
Reply With Quote
  #2  
Old 09-21-2014, 11:27 PM
thetraininglady thetraininglady is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

That looks as though it's either been created directly in Excel and then imported into the PPT slide or that an Excel worksheet has been embedded in the PPT slide.

The dates incrementing by 1 week in each cell can all be achieved using Excel formulas.
Reply With Quote
  #3  
Old 09-22-2014, 04:24 AM
JohnWilson JohnWilson is offline Windows 7 64bit Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,653
JohnWilson will become famous soon enough
Default

I would say it's just a PPT table and has been filled in manually (because the formatting is inconsistant)

If a function or macro was used it would likely say 03 - Mar NOT 3-Mar

If you know how to use a macro this will fill in a selected table with consequtive dates.

Code:
Sub fillTable()
Dim otbl As Table
Dim irow As Integer
Dim icol As Integer
Dim inc As Integer
On Error GoTo err
Set otbl = ActiveWindow.Selection.ShapeRange(1).Table
For irow = 2 To otbl.Rows.Count
For icol = 1 To otbl.Columns.Count
inc = inc + 1
With otbl.Cell(irow, icol).Shape.TextFrame2.TextRange
.Text = Format(Now + inc, "dd-mmm-yy")
.Font.Size = 12
End With
Next
Next
Exit Sub
err:
MsgBox "Have you got a TABLE selected?", vbCritical
End Sub
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #4  
Old 09-22-2014, 06:16 AM
anhnha anhnha is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 9
anhnha is on a distinguished road
Default

Thank you, thetraininglady and JohnWilson.

Could you tell me how to do that in Excel? Any link is also good.
And how can I create color like that in Excel?

JohnWilson:
I know how to create a table in PPT but I don't know how to import that macro.
Actually, I am making a report for my training and it lasted only 10 days.
I want to make a schedule for 10 days. Could you suggest a template that is good?
Reply With Quote
  #5  
Old 09-22-2014, 06:33 AM
thetraininglady thetraininglady is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

I don't have anything on my site for this function as yet but depending on how urgent it is I could write something up by the end of the week if you wanted to know how to do this yourself.

If urgent though I've just created it quickly in Excel for you. Download the sample attached and I've explained how I did it below.

If you change the date in cell D2 which is the first date then the rest of the worksheet will update. I've used 2 different types of formulas due to the layout but essentially cells E2 to G2 are just using a =D2+1 formula which just takes the first date entered and adds 1 day. All of row 2 uses this method. Then for cell A3 I've used a formula of =G2+1 which is the same but I'm following on from the end of row 2. From row 4 onwards I've just used =A3+7 which is taking the date from the cell above and adding 7 days.

So long story short if you change the date in cell D2 the rest will update.
You can now insert this into a PPT slide if you wish or use it stand alone. Use the Fill Color options in Excel to color code any of the important dates.
Attached Files
File Type: xlsx Sample_File.xlsx (13.1 KB, 5 views)
Reply With Quote
  #6  
Old 09-22-2014, 07:03 AM
JohnWilson JohnWilson is offline Windows 7 64bit Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,653
JohnWilson will become famous soon enough
Default

And here's how to do it in PowerPoint

To access the code press Alt f11

You can change the start date in the code then click the powerpoint icon to go back to the slide , select the table and View > Macro > Run
Attached Files
File Type: ppt calendar.ppt (97.5 KB, 11 views)
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #7  
Old 09-22-2014, 07:08 AM
anhnha anhnha is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 9
anhnha is on a distinguished road
Default

Well, thanks for your kind!
Your table looks great. I just did A3 row but there is a problem. Could you tell me how to fix it?
I attached my file.
Attached Files
File Type: xlsx Calendar.xlsx (9.7 KB, 2 views)
Reply With Quote
  #8  
Old 09-22-2014, 07:13 AM
thetraininglady thetraininglady is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

Ok because you've used AutoFill to copy the formula from A3 across to B3, C3, etc it hasn't worked because it's now referencing H2, I2 etc which do not have any values in them. So you need to change the formula in B3 to be =A3+1 and then AutoFill B3 across the row.
Reply With Quote
  #9  
Old 09-22-2014, 07:15 AM
anhnha anhnha is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 9
anhnha is on a distinguished road
Default

Quote:
Originally Posted by JohnWilson View Post
And here's how to do it in PowerPoint

To access the code press Alt f11

You can change the start date in the code then click the powerpoint icon to go back to the slide , select the table and View > Macro > Run
Thanks! You seem very skilled at this.
I also have basic understanding about programming but not good and doesn't use much VB.
Reply With Quote
  #10  
Old 09-22-2014, 07:20 AM
anhnha anhnha is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 9
anhnha is on a distinguished road
Default

Quote:
Originally Posted by thetraininglady View Post
Ok because you've used AutoFill to copy the formula from A3 across to B3, C3, etc it hasn't worked because it's now referencing H2, I2 etc which do not have any values in them. So you need to change the formula in B3 to be =A3+1 and then AutoFill B3 across the row.
It works like a charm!
And do you have to manually set =A4 + 7 for row 5 and = A5 + 7 for row 6,...?
Reply With Quote
  #11  
Old 09-22-2014, 07:25 AM
thetraininglady thetraininglady is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

Quote:
Originally Posted by anhnha View Post
It works like a charm!
And do you have to manually set =A4 + 7 for row 5 and = A5 + 7 for row 6,...?
If you just put your cursor in A4 and enter formula =A3+7 press Enter. It will give you the date from A3 + 7 days (1 week). You can then AutoFill that DOWN the column as far as you like. Then AutoFill A4 across all the way to column G and repeat AutoFill down each column till all the cells are filled showing the dates you are after. From row 4 down you can AutoFill without issue both down columns and across rows.
Reply With Quote
  #12  
Old 09-22-2014, 07:35 AM
anhnha anhnha is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 9
anhnha is on a distinguished road
Default

Thanks. I just did it!
There is a small problem. As in attached file, on row 11 there is an green arrow on each cell (not sure if I use it correctly, I am learning English).
Could you tell me how to remove these arrows?
Does this method work if I write the date as 1-Jan-2014?
Attached Files
File Type: xlsx Calendar_1.xlsx (10.3 KB, 2 views)
Reply With Quote
  #13  
Old 09-22-2014, 07:49 AM
thetraininglady thetraininglady is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

The green flags simply try to notify you if Excel see's a problem. Excel has noticed that your formulas are not consistent in how they are entered.

I've had a look at the file and from row 6 onwards you have a space in between the cell reference (A5) and the + symbol. Best not to use any spaces in the formulas. So it should read =A5+7 which no spaces in between each part of the formula. So click in cell A4, position your mouse over the bottom right corner of the cell till you see the AutoFill icon which looks like a cross then autofill down the column again to overwrite the entries, repeat for column B, C, D, E, F and G and the green flags should disappear.

Yes if you change the date in cell D2 to 01/01/14 the dates will all update.
I'm about to go offline so will check in tomorrow to see if all was ok.
Reply With Quote
  #14  
Old 09-22-2014, 07:56 AM
anhnha anhnha is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 9
anhnha is on a distinguished road
Default

Hi, that works!
I have another question. It is not urgent so hope you could help me tomorrow.
I want to all days and months less than 10 should appear as 01, 02, 03, ...
Is there a way to do that?
Reply With Quote
  #15  
Old 09-22-2014, 08:06 AM
anhnha anhnha is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2014
Posts: 9
anhnha is on a distinguished road
Default

Another problem about color!
My training course lasted many days in a row. If I fill the days by red color as in the attached file, it doesn't look nice!
Is there a way to highlight these days and make it nice?
Attached Files
File Type: xlsx Calendar3.xlsx (13.2 KB, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a windows 8-like scrolling in a powerpoint slide? johan_lilje PowerPoint 0 10-01-2013 07:34 AM
How to create a days countdown in powerpoint? john.kelly11 PowerPoint 3 04-09-2013 09:56 AM
Help! Need VBA solution to create CSV file and export to Google Calendar mister_audioman Excel Programming 0 01-12-2012 01:07 PM
Sync Outlook 2010 Calendar to Sharepoint Calendar paankadu Outlook 0 12-08-2011 08:25 AM
Create calendar event groegee Outlook 1 12-05-2011 09:56 PM


All times are GMT -7. The time now is 10:08 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft