copy and paste value using macro

i have created a recorded macro that bassically when clicked adds one to the cell eg if value is 10 and the button was clicked then it would turn to 11

the problem is that i want it to go down each time it is clicked therfore
when you click it would first go to A49 and then the second time it should go down to A50 therfore each time it is click the cells goes up by 1 eg A49=1 A50=2 etc
the code is below:

Please Login or Register  to view this content.

thanks in advance

it dont work bruv

it seds type mismatch

Originally Posted by shilpz

it dont work bruv

it seds type mismatch

Please Login or Register  to view this content.

It should work if you have entered the code correctly & your data is numerical.

sorry ma bad
i thought i did say thanks

dont worry i have been taught to say thanks

i thought i did

sorry bruv

hello

i need a forumula so dat entry in Cell F15 from sheet"clock" is copied and pasted in sheet "Clocking Calculation" cell "D6" but goes down each time the button is click

i have attached a sheet expalining what i mean


thanks in advance