MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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()

application.cutcopymode = false

end sub

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