Using VBA to assess the result of different input variables

Closed
ugo234 Posts 5 Registration date Tuesday October 15, 2013 Status Member Last seen October 24, 2013 - Oct 24, 2013 at 08:39 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 25, 2013 at 07:49 AM
Hello,

I have absolutely no idea how to go about this problem, and my VBA skills are quite weak. I have this data, consisting of 3 columns and a number of rows that is not constant (it could be any number of rows).

I am looking to take each value in each column, and insert it into another sheet as a variable. These 3 columns, are different variables, so go into different cells. The effect of these changes, will then be collected and deposited in cells along each row that gave the results. that is, row 1 might be 2/3/4. along the same row, just a few cells to the right, the effects of the variables (2/3/4) on different values in the equations, are deposited.

After this runs, it moves to the next line, and performs the same operation. That is taking the values along that row, inserting it into the spread sheet and depositing the results along the same line.

The macro, then stops running at the end of the table.

To be honest, I have no idea how to code this. Any help would be awesome.. Thanks

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 25, 2013 at 07:49 AM
post a small extsract of data and again explain with reff to data