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

[ChipCarlton]

Hey Folks,
I am very new here and just joined the forums. I wanted to as
how to take information from a cell on sheet #2 to sheet #1. There ar
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 i
helps at all the “digit” that will be in the initial cell (being copie
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 i
the thread. Also if I happened to post this in the wrong part sorr
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 t
use that option to help as well

 

[BenjieLop]

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.

A simple example is this ...

ASSUME that you want the contents of Cell A1 (Sheet 2) to appear in,
say, Cell C1 of Sheet 1, enter this formula in Cell A1 (Sheet 1):

=SHEET2!A1


Regards.

 

[ChipCarlton]

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.

 

[Silvabod]

=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" <[email protected]>
wrote in message
news:[email protected]...

 

[ChipCarlton]

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

 

[ChipCarlton]

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