Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add or Less data automatically.
Hi to All
I am maintaining my stock Where i want to add and less stock of my items. Is there any way if i add item it should add in that or if i less it should less automatically. E.G. Item Qty Pen 6 Tubs 5 etc... It should ask Option of ADD OR Less if click on add it add directly in Pen 7 if click on Less it less directly in pen 5 Is any help Thanks in advance. Tiya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add or Less data automatically.
You should probably create a userform where you could have a combobox contain all the items and perhaps a textbox where you could type -1, -2, -3 etc to remove that quantity or 1, 2, 3 etc to add that quantity! Regards, SImon -- Simon Lloyd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add or Less data automatically.
Check out this site and see if you can use the template for inventory
management. http://office.microsoft.com/en-us/te...CT101426031033 "Tiya" wrote: Hi to All I am maintaining my stock Where i want to add and less stock of my items. Is there any way if i add item it should add in that or if i less it should less automatically. E.G. Item Qty Pen 6 Tubs 5 etc... It should ask Option of ADD OR Less if click on add it add directly in Pen 7 if click on Less it less directly in pen 5 Is any help Thanks in advance. Tiya |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add or Less data automatically.
Thanks Simon for Reply
I don't konw more about Userform and combobox can you give me some help for crateing this. Thanks "Simon Lloyd" wrote: You should probably create a userform where you could have a combobox contain all the items and perhaps a textbox where you could type -1, -2, -3 etc to remove that quantity or 1, 2, 3 etc to add that quantity! Regards, SImon -- Simon Lloyd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
Compare data and automatically enter data. | Excel Discussion (Misc queries) | |||
automatically expand chart data series as data is added | Charts and Charting in Excel | |||
Sorting Data Automatically | Excel Worksheet Functions | |||
Sorting data automatically | Excel Programming |