Hi guys:
I have a table of data (parts inventory) in which I need to be able to extract items to another sheet with specified quantities. And then adjust the inventory.
Ideally, once I narrowed down my search/filter results and placed cursor on any of the cells on a particular line, I would like to have a button “Take”, by pressing it I want it to tell me remaining quantity (from column L) and ask Qty I’m taking, and then copy the whole string to the last blank row on another sheet (“OUT”) with that specified qty. Qty on the inventory sheet must be adjusted as well. Message box at the end telling what’s remaining would be nice too.
I managed a macro to copy a row of data from Inventory sheet to sheet OUT with a simple macro recorder. But I would like to have a button that will take me through the process of specifying the quantities and adjusting the inventory…
Please anyone help?
Thanks in advance!
Denis
I have a table of data (parts inventory) in which I need to be able to extract items to another sheet with specified quantities. And then adjust the inventory.
Ideally, once I narrowed down my search/filter results and placed cursor on any of the cells on a particular line, I would like to have a button “Take”, by pressing it I want it to tell me remaining quantity (from column L) and ask Qty I’m taking, and then copy the whole string to the last blank row on another sheet (“OUT”) with that specified qty. Qty on the inventory sheet must be adjusted as well. Message box at the end telling what’s remaining would be nice too.
I managed a macro to copy a row of data from Inventory sheet to sheet OUT with a simple macro recorder. But I would like to have a button that will take me through the process of specifying the quantities and adjusting the inventory…
Please anyone help?
Thanks in advance!
Denis
