Formula to reference cell on another worksheet

[joeyhl]

Hi guys,

I hope you could extend a little help. I've got two sheets in my workbook and what I want to do is to automate the "sheet1" upon encoding the data in "sheet2". However "sheet 1" is somehow formatted as follows:

Encircled in red is the data I intend to encode in "sheet2" in the following manner:

Under "sheet1", C4 should contain data from "sheet2" A2, "sheet1" E4, should contain data from "sheet2" B2, "sheet1" F4 will get data from "sheet2" C2, and "sheet1" N4 will get data from "sheet2" N4.

Thank you in advance.

 

[snjpverma]

Re: Help please anyone

if you want Sheet 1 (C4) to have the data from sheet 2(A2), then simply type the below formula in C4 of Sheet 1
=Sheet2!A2

Similarly you can do it for other cells too

 

[My Aswer Is This]

Re: Help please anyone

You can also do it like this:
Click on Sheet1 (C4) and enter =
then click on Sheet2 (A2) and press enter key.
The formulas will now be in the cell

 

[Macropod]

joeyhl: As per the forum Guidelines (https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html), kindly give your threads meaningful titles. A title like:
Help please anyone
doesn't qualify. I've edited the title in this case.