Google Spreadsheets: Creating a schedule more easily

ceponatia

Distinguished
Feb 23, 2010
7
0
18,510
0
Hey everybody,

At work I have to maintain a schedule for my boss in Google Spreadsheet that has 5 appointments per day, Tuesday thru Friday. Right now that involves me writing in the date and then copying and pasting it in 5 rows and then copying and pasting the time slots (9, 10, 11, 1:30, and 2:30) in the column next to them. Is there a way to just create a list from now until say a year from now of Tuesday-Friday cells? I don't think I can attach a picture so I'll kind of illustrate below what it looks like...

Wed, May 24 2017 9:00AM
Wed, May 24 2017 10:00AM
Wed, May 24 2017 11:00AM
Wed, May 24 2017 1:30PM
Wed, May 24 2017 2:30PM

Then in between each day there is a red line and in between each month there is a blue line, just for organization. I don't mind manually doing that if I have to but if there's also an automatic way to do that, that'd be sweet. Thanks for any help! :)
 

leoscott

Distinguished
Dec 30, 2009
12
0
18,570
2
I don't use Google spreadsheets, but do use Excel. This would be easy with Excel using it's autofill capability. If you can copy multiple cells into Google spreadsheets, just create it in Excel and copy and paste the result into Google spreadsheets.
 

ceponatia

Distinguished
Feb 23, 2010
7
0
18,510
0


Do you have a link to a tutorial on how to do this? I'm a spreadsheet noob.
 
Thread starter Similar threads Forum Replies Date
MBA380 Apps General Discussion 3
D Apps General Discussion 0
R Apps General Discussion 0
C Apps General Discussion 3
A Apps General Discussion 2
M Apps General Discussion 1
N Apps General Discussion 2
A Apps General Discussion 2
H Apps General Discussion 2
M Apps General Discussion 1
O Apps General Discussion 6
G Apps General Discussion 0
R Apps General Discussion 2
A Apps General Discussion 3
J Apps General Discussion 3
K Apps General Discussion 2
C Apps General Discussion 2
T Apps General Discussion 7
P Apps General Discussion 1
S Apps General Discussion 1

ASK THE COMMUNITY