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).
<tbody>
</tbody>
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.
If you want I can paste a link for my workbook from dropbox.
1 | A | B |
2 | 100 | 366 |
<tbody>
</tbody>
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.
If you want I can paste a link for my workbook from dropbox.
Last edited: