I think this code does what you are after.
For it to work, you must name the cell in your sales sheet that have the days of the week in them i.e. select H6, and in the name box type "Monday" (without the quotes). And so on for all the cells with days in them.
I also think you need to handle errors in your code. If a user enters something that does not match anything in your stock sheet, or the days etc. you need to tell the code to do something about it i.e. message box or something to ask for correct info. Or even better, have combo boxes with lists of days, items and item numbers from your stock sheets, so they are selected from the list rather than typed.
Dan
Bookmarks