Thanks... I had not tried it and I don't have 2007 here at work.
--
HTH...

Jim Thomlinson


"Ron de Bruin" wrote:

Not possible in 2007 Jim

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jim Thomlinson" wrote in message
...
Just as a word of caution when you create your workbook you can not have a
sheet called "history". Through an odd quirk of XL "history" is a reserved
word so you can not give a sheet that name (unless this is fixed in 2007).
--
HTH...

Jim Thomlinson


" wrote:

Hey there guys,

I have a problem i would like some help with,

I have Two Sheets:
The first sheet i have is Called "Real Time"
I then have a second sheet called "History"

The Real Time Sheet has data wrote into it constantly, from a outside
source.

I would like to copy cell A1 from the "Real Time" sheet and paste that
into the next empty cell in the "History" Sheet in Column A.

I would like to copy cell B1 from the "Real Time" sheet and paste that
into the next empty cell in the "History" Sheet in Column B.

I would like to copy cell C3 from the "Real Time" sheet and paste that
into the next empty cell in the "History" Sheet in Column C.

I am planing on copying these across after a set time, e.g 1 minute or
1 hour

================================================== ====================

Many Thanks In Advance,
Ash