Show value in cell from another worksheet

[ipbr21054]

Hi,

Easy question but need some help please.

Currently in cell Z1 i have =P27 which shows the value of £100.00 which is fine.

I need to now use this code but on another sheet in the same workbook but how do i write the formula to reference the worksheet to put in the cell

So cell with value in on worksheet DAILY FIGURES
The cell in question is Z1
The worksheet where it needs to be show is called END OF DAY
The cell where it is to be shown is P27

I will have another 6 to do so will follow & edit your code.

Thanks

 

[Joe4]

Let Excel do it for you!

If you go to the sheet and cell that you want to put it ("END OF DAY", cell P27) and type in the equal sign in that cell, then go to the sheet and cell you want to get the value from ("DAILY FIGURES", cell Z1) and hit Enter, Excel will put the needed range reference in there for you!

 

[ipbr21054]

Wow that was easy,never knew that

Thanks

 

[Joe4]

You are welcome!
Yep, and the great thing about doing it that way is you don't need to worry about typos or any special scenarios (like what if the sheet name has spaces in it).