Using VBA to assess the result of different input variables

[Closed]
Report
Posts
5
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
October 24, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
post a small extsract of data and again explain with reff to data