Transfer Values

Posted by Colin on December 29, 2001 3:27 AM

I need something in Excel that I can list thre numbers in three cells and those values will be placed on another page or somewhere else just below the last values entered. I would prefer to do this using a dialog or VB but regular excel sheets would be fine.

Posted by Jacob on December 29, 2001 3:18 PM

Lets say the values are in A1:C1 on Sheet1 and you want them to be put on sheet2 on the last row.

Sub MyMacro()

sheets("Sheet1").range("A1:C1").copy
sheets("Sheet2").Select
Range("A65536").end(xlup).offset(1,0).select
activesheet.paste
application.cutcopymode = false

end sub

Is this what you were looking for? Just assign the macro a hot key and you are set.

Jacob