How Do I Copy Cells From One Sheet To Another
 

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

How Do I Copy Cells From One Sheet To Another
 

Hi Ash

Start here
http://www.rondebruin.nl/copy1.htm

--

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


wrote in message ups.com...
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

How Do I Copy Cells From One Sheet To Another
 

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

How Do I Copy Cells From One Sheet To Another
 

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

How Do I Copy Cells From One Sheet To Another
 

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

How Do I Copy Cells From One Sheet To Another
 

ok then, i have not tried this yet but will get to work on it
tomorrow! i will have to change the sheet name