Hi all,

I hope someone can help with this. It is something i did years ago for a project but a lot has happend since and i have not clue.

I am building a database to show where sales reps visit on a monthly basis. i have designed macros so that at the end of every month we can export the information into a 'historic' table. I need to know how to make the historic table automatically jump to the next empty line so that previous information is not overlapped.

I'm not sure whether this is an easy fix or requires being clever with how info is pasted in but everything i have tried has failed.

cheers

Tom