Hello,
I have a solution to a problem which I do not have the knowledge about VB to get there.
My issue is I have a inventory count with a Button that I'd like to allow the user to click and be able to upgrade copy and paste by accessing a closed Inventory log workbook looking at a column using find and pasting the QTY (column next to it) in (2,0) from the matching value in the inventory count sheet
Example
Logging sheet
Serial QTY
123213 332
User clicks Update QTYS button
script looks at logging sheet and locates any matching/duplicate serials compared to inventory count work book, while its a closed document, then does the following in the inventory count workbook.
Inventory count
123213 skips 2 columns and paste 332
Much Appreciated!
Sam
I have a solution to a problem which I do not have the knowledge about VB to get there.
My issue is I have a inventory count with a Button that I'd like to allow the user to click and be able to upgrade copy and paste by accessing a closed Inventory log workbook looking at a column using find and pasting the QTY (column next to it) in (2,0) from the matching value in the inventory count sheet
Example
Logging sheet
Serial QTY
123213 332
User clicks Update QTYS button
script looks at logging sheet and locates any matching/duplicate serials compared to inventory count work book, while its a closed document, then does the following in the inventory count workbook.
Inventory count
123213 skips 2 columns and paste 332
Much Appreciated!
Sam