Ok so I have a formula in cell (A1) calculating the sum of some other cells. I want a button that i can press (on a differen sheet in the same book) that will set another cell to the current value of A1
So say A1 has added up the current set of numbers to 21 I want to press a button and have A2 = 21 and not change when A1 carries on adding things up.
Am I making sense?
Total noob at macro's so if you could explain it like I'm 5 that'd be great ^_^
So say A1 has added up the current set of numbers to 21 I want to press a button and have A2 = 21 and not change when A1 carries on adding things up.
Am I making sense?
Total noob at macro's so if you could explain it like I'm 5 that'd be great ^_^