Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba codes
i am useing excel 2000 and i have several rubber compound recipes.i have
these recipes in customer files.i have each recipe on one sheet and put the name of the recipe on the tabs.each costomer file might have up to 20 defferent recipes.and i have another file that i keep a list of all my ingrediants and the amount that i have in stock.my ?? is. is it possible to write a code that will automadicly go to my inventory and deduct the amount of ingrediant of any given recipe that i use. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba codes
Excel vba can can certainly be programmed to loop through a section of cells,
pickup the value of the cell and find that value on another sheet, then subtract the value from the right of the original cell from the cell to the right of the found cell on another sheet. It can also be programmed to be given a unique identifier for the recipe and find that identifier by looking across as many sheets as you specify or just find it on one sheet and then use the position that cell to fine the block of cells to loop through. Beyond that, your description does not lend itself specific examples. But as a demonstration, select one of your customer sheets. Turn on the macro recorder and do Edit=find and put in the unique identifier/name of that recipe. Excel should select it. then turn off the macro recorder and go to the VBE and look at the recorded code. This would be your basic search code. -- Regards, Tom Ogilvy "recipe type data" wrote: i am useing excel 2000 and i have several rubber compound recipes.i have these recipes in customer files.i have each recipe on one sheet and put the name of the recipe on the tabs.each costomer file might have up to 20 defferent recipes.and i have another file that i keep a list of all my ingrediants and the amount that i have in stock.my ?? is. is it possible to write a code that will automadicly go to my inventory and deduct the amount of ingrediant of any given recipe that i use. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zip Codes | New Users to Excel | |||
VBA codes | Excel Discussion (Misc queries) | |||
Need some help with codes | Excel Discussion (Misc queries) | |||
Zip Codes | Excel Discussion (Misc queries) | |||
Zip Codes | Excel Discussion (Misc queries) |