Hi
I have a workbook that has 2 sheets the same and what im trying to do is when Ive put the data in sheet 1 I click a macro button and it transfers the data to sheet 2 of which is exactly the same as in layout.
What I need it to do then is when I click on the macro button all future times I need the value from sheet 1 added to the current value in sheet 2
let say cell B4 on sheet 1 was £1 that carried over to B4 in sheet 2 on the first occasion. Then when I do it next time the value in B4 in sheet 1 will be lets say £2 so I need that added to value of cell B4 on sheet 2 and shown that so therefore B4 in sheet 2 would be £3.
Any Ideas?
I have a workbook that has 2 sheets the same and what im trying to do is when Ive put the data in sheet 1 I click a macro button and it transfers the data to sheet 2 of which is exactly the same as in layout.
What I need it to do then is when I click on the macro button all future times I need the value from sheet 1 added to the current value in sheet 2
let say cell B4 on sheet 1 was £1 that carried over to B4 in sheet 2 on the first occasion. Then when I do it next time the value in B4 in sheet 1 will be lets say £2 so I need that added to value of cell B4 on sheet 2 and shown that so therefore B4 in sheet 2 would be £3.
Any Ideas?