Taking a cell from sheet 2 to sheet 1 (newbie here)

Hey Folks,
I am very new here and just joined the forums. I wanted to ask how to take information from a cell on sheet #2 to sheet #1. There are going to be many instances with the workbook I am making of doing this. I just have yet to figure out how to make this happen. Also if it helps at all the “digit” that will be in the initial cell (being copied from) is going to be from a function of some sort ( ex: D4 x D8 ) Thanks for any and all answers. If this sounds confusing just ask in the thread. Also if I happened to post this in the wrong part sorry and bare with as I am new. Thank You Chip

Also my e-mail is unlocked for other users to e-mail me. Feel free to use that option to help as well.

How about if I want to take say... Sheet1!h14 and multiply that by say...4 or some given number? How would that look? how would i go about doing that in perhaps sheet 3 if you will.

=Sheet1!H14*.4.
Same for sheet 3 .... easiest way to do it is enter the = sign in the cell
where you want the calculation, navigate to the sheet and cell you want to
act on in the calculation, press Enter (which will return you to the
"active" sheet, with the sheet 1 cell entered as the multiplicand), then add
the *.4

"ChipCarlton" <ChipCarlton.1wrfua_1129071904.8302@excelforum-nospam.com>
wrote in message
news:ChipCarlton.1wrfua_1129071904.8302@excelforum-nospam.com...
>
> How about if I want to take say... Sheet1!h14 and multiply that by
> say...4 or some given number? How would that look? how would i go
> about doing that in perhaps sheet 3 if you will.
>
>
> --
> ChipCarlton
> ------------------------------------------------------------------------
> ChipCarlton's Profile:
> http://www.excelforum.com/member.php...o&userid=27808
> View this thread: http://www.excelforum.com/showthread...hreadid=473176
>

Yeah I was trying to do that but it kept saying there was some sort of error.

Yeah I have tried what you have said to do but it is not working. I always get a message in the cell that says "#name?" I have no idea why it is doing this. Could anyone let me e-mail the file to them and see if they can resolve it possibly? and give me a few pointers on how to fix this in other situations