Hi All.
There must be a smarter way.
I have two sheet, in sheet 2 (Ark2), owner can enter data, these should be copied to sheet 1 (Ark1)
(Normally sheet2 (Ark2) is hidden and user of the sheet can enter deferent data in other cell then the one we "prepopulate"
So for now, I can make this work, it is just not "nice" coding I think, there must be a smarter way to link cell together like "=Ark2,B2 or something. Hoep this makes sence and that you can help me.
Sheets("Ark2").Select
Range("A1").Select
Selection.Copy
Sheets("Ark1").Select
Range("C5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Ark2").Select
Range("B5").Select
Selection.Copy
Sheets("Ark1").Select
Range("C15").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Bookmarks