Good afternoon, I hope someone can help me....

I am currently creating an event/resource database in the form of a table in worksheet 1 (table 1).

In worksheet 2 I intend to create a summary table for every record I input in table 1. The summary table will consist of 9 rows and 54 columns.

Is there a way (in macro form I guess) to automatically create a new summary table in worksheet 2 for every record I input into table 1? Ideally the summary table that gets automatically created will state the event name (the first field in table 1).

I have tried creating pivot tables but I just can't seem to achieve what I need from the summary tables.

The summary table is very basic, 9 rows listing the 9 different resources, then 52 columns for every week of the year.

I hope this makes sense? And I hope someone can help Me?

Thanks a lot