Hello,
Currently I am using "SOLVER" to iterate values (using a formula{Column G}) in a cell of a column (col G) to match it with the corresponding cell in the next column (col H). But I have numerous rows that I have to match and could not find a way to copy it for multiple rows. In other words, I have to iterate so that G2=H2, G3=H3, .... and so on. I need to get it done urgently. Any help is much appreciated. The excel file is attached.
Thanks
P_RO_100yr Calc.xlsx
Last edited by hshahad; 07-16-2013 at 12:42 PM.
You could run solver in a loop with vba.
A macro like this should work for you.
You must also set a reference to Solver in the "Visual Basic" Window. Tools -> References and tick box marked solver.
Please Login or Register to view this content.
Alf
Worked like a breeze
My heartiest thanks to you.
Glad to be of help and thanks for feedback!
Since this seems to solve you problem could you please mark your thread "Solved"
Alf
PsTo mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks