Personally, I think I would do it the other way around. I would keep the
Master Log and make my entries there, and then write a macro to just copy and
paste the desired rows over to a Report Sheet to email out.......

hth
Vaya con Dios,
Chuck, CABGx3



"gramps" wrote:

During the course of a working day I have to email a worksheet that contains
details of traffic delays to a central control room. Each worksheet could
contain 1 incident or several on each and there could several emails during a
24 hour period. What I would like to do is produce a second worksheet that
logs each individual entry onto a master daily log. How do I get the master
log to copy each individual entry into the next available empty row of cells.
Each row of information spans over 9 columns.
Thanx for any help you can give
--
AL