ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automate Inventory (https://www.excelbanter.com/excel-programming/341860-automate-inventory.html)

jcjdoss

Automate Inventory
 

Is there any way to automate my inventory list with a macro or checkbox
to paste from one worksheet tab to another once a product is sold.

Thanks in advance


--
jcjdoss
------------------------------------------------------------------------
jcjdoss's Profile: http://www.excelforum.com/member.php...o&userid=27799
View this thread: http://www.excelforum.com/showthread...hreadid=473048


K Dales[_2_]

Automate Inventory
 
Yes, probably... but would need more info to know how to do it. How are the
two sheets arranged (rows and columns)? How does the procedure get initiated
- what tells me that a product is sold: Does the user enter a value in a
cell? Or press a command button? And how would I know how to find the
proper data from the inventory list? How would I know where it needs to be
pasted? Without details like this it is impossible to respond.
--
- K Dales


"jcjdoss" wrote:


Is there any way to automate my inventory list with a macro or checkbox
to paste from one worksheet tab to another once a product is sold.

Thanks in advance


--
jcjdoss
------------------------------------------------------------------------
jcjdoss's Profile: http://www.excelforum.com/member.php...o&userid=27799
View this thread: http://www.excelforum.com/showthread...hreadid=473048




All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com