When I click the link the message on the site says "Invalid Attachment
specified"

Only column 1 on sheet 3 is relevant here, the other columns have
independent data in them. Its just a listing of everything that is typed in
Sheet 1.
Imagine sheet 1 as a day of the week calendar ,across, and time of day,
down. You may have 2 entries for monday in row 3 and 7 , 3 for tuesday in row
1, 4, and 10 and so on...sheet 3, column 1 will just be a list of all the
entries with no spaces for cells not filled in sheet 1

"mrice" wrote:


I hope that the attached solves the first of the problems - you can see
the code by hitting ALT F11 and going to the sheet1 tab.

I don't fully understand the sheet 3 format, what happens if the data
is in something other than the first column.


+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4753 |
+-------------------------------------------------------------------+

--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=535260