many thanks for your replies, I will explore your suggestions over the next
few days.
mike
"mike scott" wrote in message
...
we enter data every 8 weeks into a spread sheet. this spread sheet has
become large enough to make locating data entry points difficult.
I have recorded a macro that allows data entry on a separate work sheet
that
is than transferred onto the main record. it worked first time round but
of
course all the insertion points have changed and any subsequent transfers.
I believe I need to write a subroutine that will take this into account,
e.g. insert line at every 7 position; change this to 8th line, than 9th
etc.
I can post the file to anyone who could help. tia
mike