Macro to update the cell below every time its pressed

[Muzza86]

I am trying to create a macro to make a process easier for an end-user with little/no knowledge of excel at all.

I need to record a macro and apply it to a button so its user-friendly.

the macro in question would be the following:

Click c5
press alt+down (to scroll to last entry in list - lets say c10)
drag formula in that cell down to cell below (into c11)

REPEAT.


now when I do this, it works perfectly for the first press of the button. HOWEVER my problem lies here:

- I need the macro to then on the second press of the button to:

click c5
press alt+down (to scroll to the last entry in list - NOW WOULD BE C11)
drag formula in that cell down to cel below (NOW INTO C12)

etc. but I cant get it to do it.

any help?

[sktneer]

Try to see if this is what you are trying to achieve.

Please Login or Register  to view this content.