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

Strange, it worked for me.

Can you drop me an e-mail via my home page and I'll send what I have
via e-mail.


--
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

I got the link to work.
So far it looks like it works perfectly. Thank you very much, this has been
bugging me for a few months now. I thought it was possible, but as I said
earlier, I'm not very proficient in many of excels functions.

"mrice" wrote:


Strange, it worked for me.

Can you drop me an e-mail via my home page and I'll send what I have
via e-mail.


--
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

No problem - glad to help.

The attachment has a refinement to cope with sheet 3.


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

--
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