I show users how to do thing simply. They don't want to write VB so after showing them how to create a user form, we would record a macro to copy the information from the captured data list to a database on another sheet.

Select the data
copy
Go to sheet with other entries
Control - down arrow
Down arrow (into a blank row)
Paste values

This always worked in previous versions but for some reason, when its run it overwrites the last entry ie: its not stepping down to a blank row.

If I perform these actions it works but for the macros when it runs it doesn't.

Any ideas please (no VB scripts as these users can't write VB code),.