Hi,
I have a problem in Excel.
I'm am looking for a macro wich saves information with many possibilities.
I will try to explain it:
In cel A2, B2, C2 and D2 in sheet1 has to come values.
For starting A2=20, B2=20, C2=20 and D2=20
After that there is some calculation with formulas in the sheet and there is a result.
The values in A2, B2, C2, D2 has to be copied in sheet2 in cel A1, B1, C1 and D1, allong with the result in cel E1.
After that the values in sheet1 cells A2, B2, C2 and D2 has to be changed, for example:
A2=30, B2=20, C2=20 and D2=20 and these values and tehe result of the calculation with these values has to be copied in the next empty row in sheet2, so that will be cell A2, B2, C2, D2 and E2.
I want to calculate the result of the formulas for every possibility of values in cel A2, B2, C2 and D2 between 20 and 100 with an interval of 10.
Can someone tell how this macro/VBA will look like?
If there is something not totaly clear about my question please let me know.
With kind regards,
Zwans
I have a problem in Excel.
I'm am looking for a macro wich saves information with many possibilities.
I will try to explain it:
In cel A2, B2, C2 and D2 in sheet1 has to come values.
For starting A2=20, B2=20, C2=20 and D2=20
After that there is some calculation with formulas in the sheet and there is a result.
The values in A2, B2, C2, D2 has to be copied in sheet2 in cel A1, B1, C1 and D1, allong with the result in cel E1.
After that the values in sheet1 cells A2, B2, C2 and D2 has to be changed, for example:
A2=30, B2=20, C2=20 and D2=20 and these values and tehe result of the calculation with these values has to be copied in the next empty row in sheet2, so that will be cell A2, B2, C2, D2 and E2.
I want to calculate the result of the formulas for every possibility of values in cel A2, B2, C2 and D2 between 20 and 100 with an interval of 10.
Can someone tell how this macro/VBA will look like?
If there is something not totaly clear about my question please let me know.
With kind regards,
Zwans
