Help for novice user

[DR RON]

HI, I am a novice when it comes to excel. i will ask my question as simply as I can. I download data from a website into a worksheet say worksheet 1,
I use the data I want by transfering it to worksheet 2, and delete the stuff I dont want. For example the data in A1 in worksheet 1 I want transferred to C1 in worksheet 2, thatsthe easy part. now I refresh worksheet 1 with new data and want the new data in A1 to transfer into C2 in worksheet 2 and so on going down a line with each update. Can anyone help with this? I am sure there is an easy answer to it, however I;m not yet experienced enough to find it. Thanks from the doctor.

 

[Zack Barresse]

edited:
sorry about the blooper.

Sub findLast()

Range("C1").Select
ActiveCell.End(xlDown).Offset(1, 0).Select

End Sub

HTH

 

[Zack Barresse]

forgot to mention - this will only find the first usused cell in C starting with row 1. not sure what else you want but it's a start

 

[HalfAce]

Hi Doc, welcome to the MrExcel board.
Another approach would be this:

Sub CopyTest()
Sheets("Sheet1").Range("A1").Copy Sheets("Sheet2").Range("C65536").End(xlUp).Offset(1)
End Sub

This help?
Dan

 

[just_jon]

If column C has holes in it, and you wish to append data below the last used cell as opposed to starting with the 1st unused cell, you can use --

Dim LastRow as Long
...
LastRow=[C65536].End(3).Row + 1
' Cells(LastRow, 3) will reference the column C cell
...