Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Excel VBA - Macro that returns and saves a value in every row"
Hello,
I would like to ask for your assistance in solving my problem in VB programming. I have a spreadsheet that computes for the industrial consumption leve in demand of a client. Say in one of the worksheets that resembles form, the user must enter in cells E12, E14, E17 & E19 all the neede information. The next thing that the user will do is to click on th 'Result' worksheet in order to assess the type of consumption leve that the client falls under, and at the same time provide us analysts/suppliers the kind of recommended chemical that such clien must integrate into their system. My excel spreadsheet works perfectly in providing the correc recommendations as per client entry. However, I would like to find way to do a batch process, in such a way that I have a separate shee containing all the client data (that is needed for the computations) One row corresponds to one distinct client entry and its subsequen information, then the program must generate the result o recommendation in a cell of the same row associated to the client saves the result in a cell of the same row, then performs the sam process for all the remaining clients in the succeeding rows. I do not have a macro command that runs this process, as I am beginner in this aspect. But I understand that this involves loop since the process will be done iteratively. Please help me i constructing a command for this, in the most descriptive an 'layman-defined' manner. Your contribution is very much appreciated. I hope to receive response on this matter the soonest possible time. Thank you. Marij -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I stop Excel's saves "Backup of ######.xlk" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions | |||
Formula format in excel that returns an "error" if there is a blan | Excel Discussion (Misc queries) | |||
"Excel VBA - Macro that returns and saves a value in every row" | Excel Programming |