Copy value from one sheet to another based on condition

Originally Posted by Marion59

Thank you for answering my question. The reason I want to do it as discribed is because management wants to see what happened in week 1, week 2, etc.

...but that's precsisely what a pivot table will allow you to do, along of course with lots more stuff. As a general rule avoid duplicating database fields which are the same data but just in a different format. A week is a series of dates, there really is no necessity to have a week number column.

Management most probably don't understand what Excel Pivot Tables can do for them. In my working life I was constantly surprised at that lack of awareness. I suggest you educate them. If you take a little time to study Pivot Tables you'll certainly learn something that will stand you in good stead and if your organisation has other very basic Excel applications you might even become the Goto source for all matters Excel.