I am trying to run a YTD sales program indexing TY actual weekly sales
against TY Plan sales. The first worksheet shows current year's actual sales
as they update weekly. The second worksheet has the Sales Plan by week for
the entire year. My third worksheet is a simple YTD indexing form to track
YTD sales against YTD Plan. How do I have a cell formatted to only accept
the values in "column B" if there is a corresponding value in "column A"?
Example: Sales TY in weeks 1-3 vs Plan sales Weeks 1-3; next week 1-4 vs
Plan 1-4, etc.