Create calendar in Powerpoint 2010

anhnha · #1 09-21-2014, 05:11 AM

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

thetraininglady · #2 09-21-2014, 11:27 PM

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.

JohnWilson · #3 09-22-2014, 04:24 AM

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

anhnha · #4 09-22-2014, 06:16 AM

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?

thetraininglady · #5 09-22-2014, 06:33 AM

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.

JohnWilson · #6 09-22-2014, 07:03 AM

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

anhnha · #7 09-22-2014, 07:08 AM

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.

thetraininglady · #8 09-22-2014, 07:13 AM

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.

anhnha · #9 09-22-2014, 07:15 AM

Quote:

Originally Posted by JohnWilson

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.

anhnha · #10 09-22-2014, 07:20 AM

Quote:

Originally Posted by thetraininglady

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,...?

thetraininglady · #11 09-22-2014, 07:25 AM

Quote:

Originally Posted by anhnha

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.

anhnha · #12 09-22-2014, 07:35 AM

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?

thetraininglady · #13 09-22-2014, 07:49 AM

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.

anhnha · #14 09-22-2014, 07:56 AM

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?

anhnha · #15 09-22-2014, 08:06 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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