New Student Macro GAH

[GuitarGal]

I have 3 columns.
A = Forename
B = Surname
C = Concatenate of the two.
ok with me so far?
Now...Macro Time...
When I go to another sheet called Insert New Student, and copy the Forename of that form, I paste special it into the correct cell.
As I do with the Surname too.
But you see, I am doing a macro right now (A very difficult one) Yet, the Concatenate formula seems to dissapear each and every time I do this, and I really don't understand why.
Please Help Me! I'm sure its something really simple, but I'm not getting it!

[Carim]

Hi Gal,

Could you share your macro ... for good advice ...

Carim

[GuitarGal]

Umm well I havent done the macro, I always delete it cuz its wrong. And from doing that now also, the damn program descides to not enter the Tutor Group and therefore I cannot go any further with my intention of this damn macro in the first place.
And I'm getting really annoyed with it lol

[Carim]

Hi,

Do you really need a macro ...?

in the destination worksheet go to the destination cell, type =
then with your mouse click on the source worksheet, go to the source cell and press enter ...

that's it ...

Carim