I am tracking missing material in a sheet, my front page is an over view, I have a summary of the type and the number associated with the order. I want to have added detail on another page where I can paste exactly what is missing. Can I create a macro or something that when prompted, (short cut or something) it will look for the selection on the sheet I added the full detail on?
