Copy Paste using VBA

[Maheshp072]

I have a worksheet in which I would like to copy last cell of sheet2 to last cell of sheet1.

To explain properly
Sheet2 last cell is B100 (text is written)
Sheet1 last cell is C150 (text is written)

I would like to copy B100 to C150, that means eventhough C150 has already some text entered into it, after copy it would replace the text.

As more data if I enter and whenever I run the VBA code the last cell should be changed accordingly, that means after several data the last cell in sheet2 may change to B300 and in sheet1 from C150 to C400, then B300 should be copied to C400 and so on

I hope you must have understood what I am trying to say.

I would like the above in VBA

[jraj1106]

Hi.

Try this code:

Please Login or Register  to view this content.

[:) Sixthsense :)]

Try this....

Please Login or Register  to view this content.

[Maheshp072]

No sir the copy is not working properly

For Eg. Sheet2 Cell B150 has text "Vehicle" in it
This B150 text should be copied to sheet1 to Cell C200 even though C200 has previously some text written in it.

[:) Sixthsense :)]

No sir the copy is not working properly

Oops... corrected code is given below..

Please Login or Register  to view this content.

[Maheshp072]

Sir your code is still not working properly

Let me explain again in detail

Sheet2 cell B150 contains "Vehicle"
This B150 that contains text should be copied to Sheet1 in cell C200

Now if C200 already contains text "Keys" the "Keys" should be replaced by "Vehicle"

[:) Sixthsense :)]

It should work, not sure what you are doing wrong at your end

Attach a sample workbook by showing what you tried for better understanding.

[jraj1106]

I have checked both the code. It does what you are asking for. I don't understand why its not working for you?

[Maheshp072]

I am sorry there was a mistake in copying your code to my file.
It is working fine
Thanks a lot