Hey everyone,

I have been tinkering around with excel a bit, and I am curious is I could
get the following done in a macro.

I have a sheet with some lists. Each list has different values from the
other list. Now I want to combine these lists into a table (not a pivot,
because data has to be inserted later) along with a calendar, maybe in a
template if that makes it easier, and then add new sheets with the name and
referenced table according to the lists. To give the example, starting from
A1 on Sheet 1.


List A List B List C Calendar
1 2 3 January
4 5 6 Feb


Then I want to have the following to end up in a table and be put in a new
sheet

Sheet 2 (named List A "Something")

List A January February
# Days % # Days
%
1 'manual input' 'formula here' 'manual input' 'formula
here'
4 'manual input' 'formula here' 'manual input' 'formula
here'

Sheet 3 (named List B "Something")

List B January February
# Days % # Days
%
2 'manual input' 'formula here' 'manual input' 'formula
here'
5 'manual input' 'formula here' 'manual input' 'formula
here'

And so on, untill it has processed all the lists. (There are now 4 in total,
but more can be added later). Regarding the formula, I am planning to put a
'manual input'/vlookup(###) kind of formula in there.

This is, for me, quite difficult, and I am not sure if that is even
possible. Maybe making a template of the tables are better, I have no idea.
Haha. But any help is welcome.

Thanks!