Get a value from a cell in a different Worksheet

[Nett]

Hi all,
Im trying to get a value from a cell in a different worksheet. I have 2 worksheets in one excel workbook and i have to pull out the values from Sheet 2 to Sheet 1. The challenge is that the positioning of the cells of both templates are not the same so i cant just use the simple vlookup function on the same cell of the different worksheets.
I've tried using this macro:

Sub NoCopyAndPaste()
Sheet2.Range("""").Copy
Sheet1.Range("""").PasteSpecial
Application.CutCopyMode = False '
End Sub

But once i make adjustments to the values in Sheet 2, the values in Sheet 1 will not change.
Is there any way the vlookup fomula can achieve this or should i use a macro?There's a TEST 2 file that i've attached.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[Phil_V]

<double post>

[royUK]

Thanks Phil

nett I have locked your other post & you have earned an Infraction. Please read & follow the simple forum rules!

[Nett]

My apology for being ignorant to the forum rules. Rest assure it won't happen again.

[royUK]

Thank you, you only need to read them & ask if you are unsure. You did agree to them when joining

[Phil_V]

So now all the tags and everything else have been sorted out, what exactly are you trying to achieve?

Do you just want the values from Sheet2 shown in the correct places on Sheet1?

I might be asking the obvious here, but why not just fill the values in on Sheet1 in the first place?

If you REALLY need to fill them in on Sheet2 and have the values shown on Sheet1 then select a cell on Sheet1 and press [=] on your keyboard, then using the mouse select Sheet2 and click the cell you want the value from, and press [Enter].

[Nett]

Im trying to find a faster way by using macro where i can transfer the values from Sheet 2 to Sheet 1. For values that are in Sheet 2 but not in Sheet 1 are to be stated as null. Is there a need to find the cell position for both worksheet.?

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!