So I am back at it again ... sorry for all the dumb question but I am new to this ... i want to add to that excellent example that was givin earlier... what I want to do is when it it search finds a copies the row... i want it to subtract one (-1) from the variable in column H... also I eventually plan to move all this macros and buttons to sheet three but I want it to continue searching sheet one... is this possible?