Transfering information from one cell to another

[garr]

I'm using Excel 2003
I have a workbook open and am using 2 worksheets. On sheet 1 I get
information from the internet and then transfer three cells of it to sheet
2. Sheet 1 updates every time I open the workbook. How do I get sheet 1 to
put the information into a different cell in sheet 2 each time it updates. I
would like to get them to follow the dates down a column.

Garry
[email protected]

[JE McGimpsey]

One way:

This will transfer one value from sheet 1, cell A1 to sheet 2, column A.
You may be able to adapt it for three cells, but the best implementation
will depend on which three cells you're transferring and which cell(s)
the information should go into.

Put this in the worksheet code module of sheet 1 (right-click the
worksheet tab and choose View Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target(1)
If .Address(False, False) = "A1" Then _
Sheets("Sheet 2").Cells( _
Rows.Count, 1).End(xlUp)(2, 1).Value = .Value
End With
End Sub

Change the range references as desired.

If you're not familiar with macros, see David McRitchie's "Getting
Started with Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm


In article <zAfRd.417392$8l.115605@pd7tw1no>,
"garr" <[email protected]> wrote:

> I'm using Excel 2003
> I have a workbook open and am using 2 worksheets. On sheet 1 I get
> information from the internet and then transfer three cells of it to sheet
> 2. Sheet 1 updates every time I open the workbook. How do I get sheet 1 to
> put the information into a different cell in sheet 2 each time it updates. I
> would like to get them to follow the dates down a column.

[garr]

This is a little more info on what I'm tring to do
I have down loaded stock info into sheet 1 and would like to transfer it to
sheet 2. Each piece of info in the cells in sheet one will be transferred to
cells in sheet two into a different column with a date of that day at the
beginning of each row on sheet two. Every day I will update sheet one and
would like it to update the info on sheet two in the next row down and not
update the previous row (leave the previous row with the last days info)

Garr

"garr" <[email protected]> wrote in message
news:zAfRd.417392$8l.115605@pd7tw1no...
> I'm using Excel 2003
> I have a workbook open and am using 2 worksheets. On sheet 1 I get
> information from the internet and then transfer three cells of it to sheet
> 2. Sheet 1 updates every time I open the workbook. How do I get sheet 1 to
> put the information into a different cell in sheet 2 each time it updates.
> I
> would like to get them to follow the dates down a column.
>
> Garry
> [email protected]
>
>
>