VBA - increment stop on a adjacent value

[zzyasia]

I need help with VBA.

Increment a value from 0 and stop the value depending on the adjacent calculated value (i.e. 90%)
The adjacent calculated value depends on the incrementing value (as you increase 0 to x, the adjacent percentage value increases)
I want it to stop when it reaches pre-defined value of % for all rows.

Thanks in advance

 

[Joe4]

Welcome to the Board!

Your question is difficult to understand without any visual aids. It would be most beneficial if you could show us an example of your data, and what you want your expected output to look like.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[zzyasia]

Sorry
where x = 0;
so increment x by 1 until Column C reaches pre-defined value (i.e. 90%)
Hopefully this gives better visual

Column A (fixed)	Column B (Qty)	Column C (Percentage changes on column B value and fixed value of Column A) - defined 90%
.2414	x	y
.93577	x	y
11.79	x	y

 

[Joe4]

It still isn't quite clear to me what you are after?
Can you please show me an example where you show what the values in column B and C are supposed to be, so we can see the pattern?
(Show me want you want/expect to see when finished).