Generating a Leaves Table in the specified format.

[e4excel]

Dear Forum,

I am trying to make a Table using Formulas instead of Pivot Tables.
I have two Sheets
1. Leaves Page
2. Leaves Form

In the Leaves Page sheet I choose the Type of leaves and mention the Start Date and End Date, I get the Total days leave Taken as well as the Balanced Leaves.

But In the Leaves Form Sheet, Im looking to generate a table in the way as shown in the attached file.

The first type of leave chosen in Leaves Page sheet should appear in the second row of the Leaves Form sheet and then the next leave should appear after apprpriate number of rows (i.e. Total Leaves Taken).

Similarly the Dates column should display the Start Date as well as all the dates in between the End Date as mentioned in Leaves Page sheet.

[e4excel]

Bump no response

[e4excel]

Any Ideas...

ANy suggestions

[e4excel]

Dear Forum,

Is this possible...

I can actually automate the entire file and have a Leaves Form displaying the leaves selected in the Leaves Form page..

Please gurus and mahagurus...