Need help in creating Sheet by using user defined data

**LampCommandr** · 07-15-2011, 03:14 PM

Hey folks,

I'm trying to create a flat file for processing against that holds a handful of data based on criteria.

First off, I have a list of 100 sites (Table_Sites) and I want to create a file that takes a user's input of date ranges, and creates rows of data for each site related to the date range inputted.

If the user inputs the date range (7/1/2011 - 7/31/2011), I would like to create a file that has the Site # on each row as many times as there are dates with each date on a row. Then to also have a combination of the site and date as a unique "setup" identifier on another column in each row.

Basically, I need a process that loops to create this file taking the date range into consideration.

I have included a copy of the file as a reference for the desired output.

**Leith Ross** · 07-15-2011, 05:30 PM

Hello LampCommandr,

It is difficult to propose a solution when key information is missing. The workbook presumably shows the desired output. What then does the sheet look like beforehand?