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

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

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.
--
Al


"CLR" wrote:

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

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





"gramps" wrote:

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.
--
Al


"CLR" wrote:

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

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.
--
Al


"CLR" wrote:

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





"gramps" wrote:

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.
--
Al


"CLR" wrote:

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

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

Vaya con Dios,
Chuck, CABGx3


"gramps" wrote in message
...
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.
--
Al


"CLR" wrote:

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





"gramps" wrote:

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.
--
Al


"CLR" wrote:

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