Daily log

[Guest]

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

 

[Guest]

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

 

[Guest]

Thanx for that thinking about it what you say makes good sense. However the
next bit is could you help with a macro suitable for the purpose as I am a
complete dunderhead when it comes to macros. Once again many thanx.

 

[Guest]

I can try.......it's difficult without "being there", it would be best if you
had a local guru there to see what you have and get your criteria first
hand......., but sans that we can try this.......using a copy of your file
for safety, first click on the Tools > Macro > RecordNewMacro....then type in
a name and press ok........then go ahead and highlight the area of cells you
wish to transfer and do Copy, then go to where you want to paste them and
click Paste, then do Tools > Macros > StopRecording.....you now have a macro
that will do that same thing all over again by just doing Tools > Macro >
Macros and selecting your new macro name and pressing Run.......try this a
time or two to get a feel for it. Post back with your results/questions.
When you finish and save this workbook, the macros are saved with it.

hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanx very much for your help I have now got it sorted out by following your
guide and with a couple of minor adjustments its all up & running.

 

[CLR]

Great!.........glad you got it working, and thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3