building tables in Excel
 

This is probably not possible without using VBA (or a PivotTable hack),
but I thought I'd ask. I'm trying to create a workbook where the setup
(rows & columns) of a table is dependent upon entries in other tables
or cells.

For example, I have one table where I can enter information for
different "tasks", and I want to create a second table where each task
from the first table will have it's own column. So one table would be:

Task, description, begin date
Get data, blah, 1/1/2006
Format data, blah, 4/1/2006
Build report, blah, 9/1/2006
etc

And the next would be:

Name, Get data, Format data, Build report, etc
Joe, 10%, 60%, 0%, etc
Jane, 60%, 0%, 0%, etc
Jim, 0%, 0%, 100%, etc
Julie, 30%, 40%, 0%, etc

(there's a column in the second table for each entry in the first
table)

Elsewhere I have an entry for "begin date" and "end date", and I want
to create a table with one row for each week between the begin date and
end date.

Is there any way to do this without using macros? (P.S. should I just
switch to MS Access?)

Thanks.