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

Hi Ash

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

--

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


<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>

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


"(E-Mail Removed)" 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
>
>

Not possible in 2007 Jim

--

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


"Jim Thomlinson" <James_Thomlinson@owfg-Re-Move-This-.com> wrote in message
news:B3F301A8-3FD2-42D6-AB21-(E-Mail Removed)...
> 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
>
>
> "(E-Mail Removed)" 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
>>
>>

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" <James_Thomlinson@owfg-Re-Move-This-.com> wrote in message
> news:B3F301A8-3FD2-42D6-AB21-(E-Mail Removed)...
> > 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
> >
> >
> > "(E-Mail Removed)" 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
> >>
> >>
>
>

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