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

C

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
 
B

BenjieLop

ChipCarlton said:
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.
Click to expand...

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.
 
C

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.
 
C

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
 
Top