Thread: Create calendar in Powerpoint 2010
View Single Post
 
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