Hi all,
Not the greatest VB guy but trying to muscle through.
I have a spreadsheet with past ordering data for certain items our company sells. When a sale comes I mark the items on the sale with an "x" in a certain column then I have a macro button that takes the average of all the items I have marked with an x, adds 10% for safety sake, then spits out the number of that item I should order. I am trying to eliminate the step where I print out the salebook then go through my huge list of items placing the x's manually.

What I would like is to type the name of the workbook in a cell, click a button and have a macro that searches for the unique item numbers in the sale book, and if that item is present, places a corresponding "x" in the column for the matching item in my spreadsheet.
I hope that makes sense.

Thanks!