Data extraction for a given date range date by date

[srinivas sandan]

Hi Everyone,

This is my first post in this forum.
A big thanks to all here who selflessly help people around the world solve their excel issues.
A bigger thanks to Chandoo who makes all this possible with a wonderful site like this.

My question:
I capture few fields of information using a user form. Two among them are the "Start Date" and "End Date" fields. All the fields get captured in an excel spreadsheet with their respective field names. For eg:

Name, Type of Leave, Start Date, End Date, etc..

Here is what i need:

I need the information replicated for all the dates mentioned, from Start Date to End Date.

For eg: If Start Date is 15th June and End Date is 20th June, I need 6 rows of the same data replicated in my database. This is required to find out how many people have taken leave on any given date.

Is this possible?

Thanks in anticipation
Regards - Sandan

 

[Somendra Misra]

Hi Sandan,

Welcome to chandoo.org forum.

May be you should upload a sample file with the sheet of data that is being entered through userform & a sample output of what your requirement is.

Regards,