Formula help on information sharing between 3 worksheets

I dont understand. I am not very proficient with many of the functions in
excel.

"mrice" wrote:

>
> I would suggest that you set up a macro linked to the
> worksheet_change_event on sheet1 which looks for the trigger words and
> copies as appropriate to your two other sheets.
>
>
> --
> mrice
>
> Reserach 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 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.

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.

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.