Putting Input box into existing code

Thank you to RYLO, this code is great!


http://www.excelforum.com/excel-prog...ste-issue.html


On the "If not Isempty" line, I am trying to input a box prompt. Instead of standardizing this macro, I want the user to be able to select a dollar amount to search and place on sheet3. Right now it works fine using 1.29 as the amount. However, I have other stores where this dollar amount is different, so I want the store managers to be able to choose an amount to search, for example 1.39, 2.99 etc...

Could someone please edit this code?

Please Login or Register  to view this content.