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 assistance in this VBA programming problem o mine. I have a form which users need to fill out in order for my spreadshee to compute for a certain industrial consumption level in demand. Say they input in cells, E12, E14, E17 & E19, the necessary data I need The next thing that the user will do is to click on the 'Result worksheet to assess the categories of consumption levels they fal under and readily provide us, the users (analysts/suppliers), with recommendation on the type of chemical they need to integrate int their system. My spreadsheet provides correct and accurate diagnosis as per clien data entry into the mandatory fields or cells I mentioned above. Bu how can I do a batch process in such a way that I have a separate shee that contains all client data (for the 4 fields), one client per row and computes, then captures and saves the results in cells of the sam row as that particular client information, iteratively for all th succeeding rows of clients? I have no command yet for the macro as I am a beginner in this aspect I know that somehow this will require loops for there are iterations but can you please provide me a descriptive command on how to run thi (say, by defining variables)? Really need all the help in this. Your contribution is very muc appreciated. Hope to get response as soon as possible. Thanks -- 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 If statement that is supposed to return a "" instead returns a 0 | Excel Worksheet Functions | |||
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) |