I am trying to create a workbook that will take input from certain
cells and populate that data in a particular cell on sheets 2 and 3.

This will be to save people from retyping informaiton and provide me
the important information I need.

So I want to have a workbook with multiple worksheets for different
data to be entered but when the person puts in their name, department,
and phone it will automatically populate the cells on those additional
sheets.

I hope I have explained this clearly enough. I can do it manually by
selecting all sheets and putting data in one of them, but my users are
not going to be able to do this.

Thanks,
Sam

samhenry, you could use a formula like this in sheet 2 and 3 to get the data
from sheet 1 =Sheet1!A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"samhenry" wrote in message
oups.com...
I am trying to create a workbook that will take input from certain
cells and populate that data in a particular cell on sheets 2 and 3.

This will be to save people from retyping informaiton and provide me
the important information I need.

So I want to have a workbook with multiple worksheets for different
data to be entered but when the person puts in their name, department,
and phone it will automatically populate the cells on those additional
sheets.

I hope I have explained this clearly enough. I can do it manually by
selecting all sheets and putting data in one of them, but my users are
not going to be able to do this.

Thanks,
Sam

Thanks for that help... Got me up and running.

I am now trying to get B15 to perform a check on C15 and if it has text
put text from C3 in B15 If there is nothing in C15 leave B15 blank.

I thought I had it with =IF(C15="","",C3). So I did this for about 10
cells
IN cell B16 I put =IF(C16="","",C3).
IN cell B17 I put =IF(C17="","",C3).
IN cell B18 I put =IF(C18="","",C3).
This was a pain because dragging the box always wanted to change the
Value for C3-(C4,C5,.....) So I basically had to manually type each
cell, which I did not mind because I thought I had it (and on my
own-Well kind of deciphered text from another spreadsheet)

At first I thought this worked because the cell was blank and If I put
text in C15 I would see B15 populate with the Value of C3.
So I tested all my cells-- Then I removed my text from C15 down so they
were blank... For some reason Column B kept the value of C3 eventhough
Column C was blank.

Why does B15 not change back when I remove text from C15 ?
When I use =Sheet1!A1 in a cell and change the value in Sheet1!A1 the
value changes immediately.

How do I get B15 to change back to "blank" whe I change the value of
C15.
I thought I was so close.

Also Can anyone suggest good resources for learning this type of stuff?
Maybe online?

Thanks-- for your thoughts....
Sam


Paul B wrote:
samhenry, you could use a formula like this in sheet 2 and 3 to get the data
from sheet 1 =Sheet1!A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"samhenry" wrote in message
oups.com...
I am trying to create a workbook that will take input from certain
cells and populate that data in a particular cell on sheets 2 and 3.

This will be to save people from retyping informaiton and provide me
the important information I need.

So I want to have a workbook with multiple worksheets for different
data to be entered but when the person puts in their name, department,
and phone it will automatically populate the cells on those additional
sheets.

I hope I have explained this clearly enough. I can do it manually by
selecting all sheets and putting data in one of them, but my users are
not going to be able to do this.

Thanks,
Sam

Sam, B15 should go back to blank when you delete the data from C15, are you
deleting it? I have seen people use the space bar to clear cells out, if
this is the case C15 in not blank and B15 will show the valve of C3.

Looks like you want B15-B?? to show the valve of C3 when something is put in
them, if that is the case you could put
=IF(C15="","",$C$3) in B15 and drag down, C3 will not change then

And have a look at the links posted on this site, under the heading of,
Excel Lessons & Tutorials (#tutorials)
http://www.mvps.org/dmcritchie/excel/excel.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"samhenry" wrote in message
ups.com...
Thanks for that help... Got me up and running.

I am now trying to get B15 to perform a check on C15 and if it has text
put text from C3 in B15 If there is nothing in C15 leave B15 blank.

I thought I had it with =IF(C15="","",C3). So I did this for about 10
cells
IN cell B16 I put =IF(C16="","",C3).
IN cell B17 I put =IF(C17="","",C3).
IN cell B18 I put =IF(C18="","",C3).
This was a pain because dragging the box always wanted to change the
Value for C3-(C4,C5,.....) So I basically had to manually type each
cell, which I did not mind because I thought I had it (and on my
own-Well kind of deciphered text from another spreadsheet)

At first I thought this worked because the cell was blank and If I put
text in C15 I would see B15 populate with the Value of C3.
So I tested all my cells-- Then I removed my text from C15 down so they
were blank... For some reason Column B kept the value of C3 eventhough
Column C was blank.

Why does B15 not change back when I remove text from C15 ?
When I use =Sheet1!A1 in a cell and change the value in Sheet1!A1 the
value changes immediately.

How do I get B15 to change back to "blank" whe I change the value of
C15.
I thought I was so close.

Also Can anyone suggest good resources for learning this type of stuff?
Maybe online?

Thanks-- for your thoughts....
Sam


Paul B wrote:
samhenry, you could use a formula like this in sheet 2 and 3 to get the
data
from sheet 1 =Sheet1!A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"samhenry" wrote in message
oups.com...
I am trying to create a workbook that will take input from certain
cells and populate that data in a particular cell on sheets 2 and 3.

This will be to save people from retyping informaiton and provide me
the important information I need.

So I want to have a workbook with multiple worksheets for different
data to be entered but when the person puts in their name, department,
and phone it will automatically populate the cells on those additional
sheets.

I hope I have explained this clearly enough. I can do it manually by
selecting all sheets and putting data in one of them, but my users are
not going to be able to do this.

Thanks,
Sam

Thanks for the feedback and link- You were right on I hit the space bar
in my test cells :) Whew.. I feel better..


Paul B wrote:
Sam, B15 should go back to blank when you delete the data from C15, are you
deleting it? I have seen people use the space bar to clear cells out, if
this is the case C15 in not blank and B15 will show the valve of C3.

Looks like you want B15-B?? to show the valve of C3 when something is put in
them, if that is the case you could put
=IF(C15="","",$C$3) in B15 and drag down, C3 will not change then

And have a look at the links posted on this site, under the heading of,
Excel Lessons & Tutorials (#tutorials)
http://www.mvps.org/dmcritchie/excel/excel.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"samhenry" wrote in message
ups.com...
Thanks for that help... Got me up and running.

I am now trying to get B15 to perform a check on C15 and if it has text
put text from C3 in B15 If there is nothing in C15 leave B15 blank.

I thought I had it with =IF(C15="","",C3). So I did this for about 10
cells
IN cell B16 I put =IF(C16="","",C3).
IN cell B17 I put =IF(C17="","",C3).
IN cell B18 I put =IF(C18="","",C3).
This was a pain because dragging the box always wanted to change the
Value for C3-(C4,C5,.....) So I basically had to manually type each
cell, which I did not mind because I thought I had it (and on my
own-Well kind of deciphered text from another spreadsheet)

At first I thought this worked because the cell was blank and If I put
text in C15 I would see B15 populate with the Value of C3.
So I tested all my cells-- Then I removed my text from C15 down so they
were blank... For some reason Column B kept the value of C3 eventhough
Column C was blank.

Why does B15 not change back when I remove text from C15 ?
When I use =Sheet1!A1 in a cell and change the value in Sheet1!A1 the
value changes immediately.

How do I get B15 to change back to "blank" whe I change the value of
C15.
I thought I was so close.

Also Can anyone suggest good resources for learning this type of stuff?
Maybe online?

Thanks-- for your thoughts....
Sam


Paul B wrote:
samhenry, you could use a formula like this in sheet 2 and 3 to get the
data
from sheet 1 =Sheet1!A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"samhenry" wrote in message
oups.com...
I am trying to create a workbook that will take input from certain
cells and populate that data in a particular cell on sheets 2 and 3.

This will be to save people from retyping informaiton and provide me
the important information I need.

So I want to have a workbook with multiple worksheets for different
data to be entered but when the person puts in their name, department,
and phone it will automatically populate the cells on those additional
sheets.

I hope I have explained this clearly enough. I can do it manually by
selecting all sheets and putting data in one of them, but my users are
not going to be able to do this.

Thanks,
Sam