VBA copy/paste first cell and recalculate formula

[pao13]

Hi. English is not my native language so please bear with me. I have a problem with circular reference error because column B is determined by column A in my workbook. But I want A2 to have the same value with current value of B2 366. If I copy paste values A2 to B2, A2 will be what I want but B2 will change to 100 (which is also what I want).

1AB
2100366

So if possible I would like a VBA that copy pastes the first value of B2 to A2 and then lets the formula work. Then for A3 to take the current number of B3 which will change after the paste to A3. etc.

Hope you understand what I'm trying to do.

 

[Luke M]

Sorry pao13, but I have no idea what is going on. I don't know what formulas/values are in A2 or B2. How are things getting calculated? What are the inputs?

 

[pao13]

Thank you for your answer Luke! This is the topic I explain in detail my problem. http://forum.chandoo.org/threads/multiple-ifs-and-maximum-value.23620/#post-142939
If you could take a look I would really appreciate it!