Hi all,
this is my first time posting and I'm a beginner at programming macros in Excel, so please go easy on me!
What I'm trying to do is creating a warehouse/inventory system. Here's how it works:
"Inventory List" sheet shows all items in the warehouse and flagged when it needs to be restocked.
"Inventory Pick History" shows a record of items going in and out of the warehouse.
To use the form, fill in all the yellow colored cell in "Inventory Pick History". SKU field should match the ones available in "Inventory List", then the description and other fields should be filled automatically.
After filling all the yellow cells, click "INPUT", then the macro will run. Here's the problem. The macro is working as I intended, but it is incredibly slow.
Below is the code for the macro:
Basically what it does is add a new row at the end of the table, fill in all the data from the yellow cells, and updates the quantity in the item list. I am using a pretty good computer (its running CAD programs just fine). MS Excel 2010, Windows 7 64-bit. I attached the file also if anyone would like to take a look at it.
Warehouse Inventory Trial.xlsm
I tried looking it up online but still haven't got a clue why this is the case. Thank you for your help/advice in advance!
Bookmarks