You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Thankx Chris......here are the answers:
-Where are you entering your information?
A table into sheet1 which is considered the Sales Report
-how are you entering your information?
simply by writing them by key board
-how is the stock quantity held in the other sheet?
It is a built list of the items (name and quantity) held in my storage
-what have you tried already?
I am tring to use loop and for each, but so far no achivment yet for the wanted task
-why aren't you using a database?
cuz Excel is very flexiable programme in commpareson, so prefered to utilise this feature of Excel....
hope i answred your Qs Chris
King Regards to all...........