Hi- new to these forums, and quite new to Excel so apologies if this is a mind-numbingly dull or predictable question!

I am creating a Gantt-chart lite (not very heavy duty) and want to do the following:

Have 2 columns which refer to lists. These will be for start date (day of the month) and task. There are around 8 or 9 possible tasks, which take anywhere between 10-28 days with individual tasks allocated to each day. The subsequent columns are for the days of the month.

What I would like is for the day columns to be auto-filled, based on the choices of date & task- so if I were to select Task 1 to start on the 6th, and task 1 takes 7 days to complete, the cells representing the 6th-12th would be filled with the values for each day's task.

I don't have access to MS project, which would greatly simplify this process, so setting up a sheet that can do all that would save me a HEAP of time.

thanks!