03 January 2017
How do I get the first column to Auto datafill without copy
Dinner 14 50
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
3 Entries per day autofill
0
DATE
MEAL
TEST
INSULIN
01 January 2017
Breakfast
25
50
01 January 2017
Lunch
15
55
01 January 2017
Dinner
16
50
02 January 2017
Breakfast
23
50
02 January 2017
Lunch
24
60
02 January 2017
Dinner
10
55
03 January 2017
Breakfast
9
50
03 January 2017
Lunch
12
50
Discussion
I really don't understand what you are trying to do here. Please include a sample file and a more thorough explanation.
don (rep: 1989) Apr 20, '17 at 5:20 am
I vote sample file :P
cappymer1 (rep: 120) Apr 20, '17 at 10:57 am
I run the lottery syndicate at work and therefore the first column looks as follows
Tuesday April 18 2017 Friday April 21 2017 Tuesday April 25 2017 Friday April 28 2017 Tuesday May 02 2017 Friday May 05 2017 Tuesday May 09 2017 Friday May 12 2017 Tuesday May 16 2017 Friday May 19 2017 Tuesday May 23 2017
How do I data fill up to August for instance without having to type each individual day in
Thanks
Malcolm
Tuesday April 18 2017 Friday April 21 2017 Tuesday April 25 2017 Friday April 28 2017 Tuesday May 02 2017 Friday May 05 2017 Tuesday May 09 2017 Friday May 12 2017 Tuesday May 16 2017 Friday May 19 2017 Tuesday May 23 2017
How do I data fill up to August for instance without having to type each individual day in
Thanks
Malcolm
MadMal204 (rep: 2) Apr 24, '17 at 4:56 pm
Edit your question and include a SAMPLE FILE! The data is not clearly readable the way you posted it.
don (rep: 1989) Apr 26, '17 at 8:34 am