On Saturday, March 7, 2015 at 12:29:23 AM UTC-8, Claus Busch wrote:
Hi Howard,

Am Sat, 7 Mar 2015 00:22:44 -0800 (PST) schrieb L. Howard:

If you search for WEEK 3 then code should return Row 1 and the row of WEEK 3 for each sheet that has a WEEK 3.

With a blank row between each.

now I know that. But before one hour I still had not enough coffee and
so I wrote code and uploaded the file and then I read your question. I
thought you enter data in Master and then distribute data to the
different sheets.
In my last answer I revised my mistake.


Regards
Claus B.
--


Thanks Claus,

Sub WeeklyReader2() - really works well, and brings up a question I had not thought of.

I was assuming, if you searched WEEK 3 and the data shows up on Master correctly as it does, then if you searched WEEK 2 then that data would list BELOW the current data on Master.

I am thinking that is preferred. In the short time I looked at the code I was puzzled about how to make that happen along with starting in row 1 when the Master sheet is blank.

Also, at this point, I am thinking that week numbers will be the same row on each sheet so the method of entering the week number instead of a string like
"WEEK 2" should be fine. If not I will tinker with it, but might as well leave it as is.

Howard