harleyd
04-13-2005, 10:10 PM
I need help to create a macro to do the following:
Spreadsheet has the following columns among others
UPC Qty Ord Qty Rcvd.
I need to open a input box that will accept keyboard or scanner input.
Find the upc scanned.
Move the cursor to the qty rcvd col in the row where the upc was found, open a input box and wait for input.
When input is entered return to beginning
If upc is not found then display an msg box "Error upc xxx not found.
When ok is hit return to start.
I receive the spreadsheet already populated except for qty rcvd column which I will add before I start to process.
I would like to be able to copy the macro to any sheet or use with any open sheet.
I need to be able to change the column locations if necessary in the macro either by editing the macro or other form.
Thanks in advance for any assistance.
Spreadsheet has the following columns among others
UPC Qty Ord Qty Rcvd.
I need to open a input box that will accept keyboard or scanner input.
Find the upc scanned.
Move the cursor to the qty rcvd col in the row where the upc was found, open a input box and wait for input.
When input is entered return to beginning
If upc is not found then display an msg box "Error upc xxx not found.
When ok is hit return to start.
I receive the spreadsheet already populated except for qty rcvd column which I will add before I start to process.
I would like to be able to copy the macro to any sheet or use with any open sheet.
I need to be able to change the column locations if necessary in the macro either by editing the macro or other form.
Thanks in advance for any assistance.