Hello everyone. I wonder if someone can help.

I have a list of data imported into an Excel spreadsheet into a sheet
called "import".
Everytime the data is imported, the length could be different, but the
range will always be A: to F (starting in row 1 with headers).

Column A - unique identifier (text string)
Column B - first date
Column C - second date
Column D - difference beween C and B
Column E - city (text string).

What I would like to create (in VBA) is a macro to take the data in
sheet "Import"
and copy it into a new sheet and create a new line for each new unique
identifer with multiple entries depending upon the difference in column
D.

For example. a line with the following information in "import"
Column A: A12345
Column B: 21/12/2003
Column C: 24/12/2003
ColumN D: 3
Column E: New York.

Would produce the following output:
A12345 21/12/2003 3 New York
A12345 22/12/2003 3 New York
A12345 23/12/2003 3 New York
A12345 24/12/2003 3 New York

Whereas, the same information but between 21/12/2003 and 22/12/2003
would show:

A12345 21/12/2003 1 New York
A12345 22/12/2003 1 New York.

Any and all help gratefully received.
Thank you.
Scott.


--
scottwilsonx
------------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128
View this thread: http://www.excelforum.com/showthread...hreadid=263823