LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Excel simple stock control

I am a service engineer, and i'm looking to use excel to manage my stock better

I have tried a few things and it's all manually input/edited

I would like to know if it's possibale to use VB, to auto manage these levels
IE, 1 box asks for the part number
2nd asks you how many
3rd/4th boxes are "+", "-"

When + or - is pressed the part number will automatically add's/subtracts
that part level.

Say.. I had 10x abcde's I enter 2 in "How Many", then press "-" it will then
adjust the level from 10 to 8

My excel sheet would have parts in it
Col1------Col2------Col 3
Part No---Desc------Qty
ABCDE----Bits-------10

Can any one please help

Thanks in advise for anyones help

Tony
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I set up stock control sheet in excel Honey Excel Worksheet Functions 2 May 24th 06 07:03 PM
Stock Control with Excel 2003??? computime Excel Discussion (Misc queries) 10 February 20th 06 02:02 PM
Simple Stock Control Sheet alanled New Users to Excel 1 February 10th 06 06:33 PM
Are there any template stock control sheets in Excel? Confused Mel Excel Discussion (Misc queries) 0 April 14th 05 02:37 PM
where can i get an excel sheet for stock control ricey111 Excel Discussion (Misc queries) 1 February 11th 05 05:58 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"