View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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