"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