Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 07, 05:37 PM posted to microsoft.public.excel.misc
lrb lrb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 4
Default Need to link dropdown box choice to another cell

I'm NOT proficient at Excel to say the least ... I have created a dropdown
box and want the choice selected in that cell to be pasted into another cell
within the same worksheet automatically. Is this possible? Can you explain
in VERY simple steps? Thank you!

  #2   Report Post  
Old December 12th 07, 05:47 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 419
Default Need to link dropdown box choice to another cell

lrb,

You can just use a formula to refer to the cell with the dropdown.

Lets say your drop down is in A1 and you want the choice selected in A1 to
display in B1:
in B1, enter the folowing formula:

=A1

Now B1 will always show the exact same thing in A1.......EXCEPT.........if
A1 is blank, then B1 will show 0 (zero). If you want B1 to appear blank as
well then use the following formula:

=if(A1="","",A1)

Also, B1 will automatically change every time A1 is changed.

HTH,

Conan




"lrb" wrote in message
...
I'm NOT proficient at Excel to say the least ... I have created a dropdown
box and want the choice selected in that cell to be pasted into another
cell
within the same worksheet automatically. Is this possible? Can you
explain
in VERY simple steps? Thank you!



  #3   Report Post  
Old December 12th 07, 07:24 PM posted to microsoft.public.excel.misc
lrb lrb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 4
Default Need to link dropdown box choice to another cell

Thank you Conan ~ that's exactly what I needed. One more question ... I
tried to copy and paste to the following rows and the formula was
automatically changed from A1 to A2, A3, etc. How can I keep the formula a
constant when copying?

"Conan Kelly" wrote:

lrb,

You can just use a formula to refer to the cell with the dropdown.

Lets say your drop down is in A1 and you want the choice selected in A1 to
display in B1:
in B1, enter the folowing formula:

=A1

Now B1 will always show the exact same thing in A1.......EXCEPT.........if
A1 is blank, then B1 will show 0 (zero). If you want B1 to appear blank as
well then use the following formula:

=if(A1="","",A1)

Also, B1 will automatically change every time A1 is changed.

HTH,

Conan




"lrb" wrote in message
...
I'm NOT proficient at Excel to say the least ... I have created a dropdown
box and want the choice selected in that cell to be pasted into another
cell
within the same worksheet automatically. Is this possible? Can you
explain
in VERY simple steps? Thank you!




  #4   Report Post  
Old December 12th 07, 07:26 PM posted to microsoft.public.excel.misc
lrb lrb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 4
Default Need to link dropdown box choice to another cell

Thank you Conan ~ that is exactly what I needed. One more question ... I
tried to copy and paste the formula to the rows below. The formula was
automatically changed from A1 to A2, A3, etc. How can I keep it a constant
when copying and pasting?

"Conan Kelly" wrote:

lrb,

You can just use a formula to refer to the cell with the dropdown.

Lets say your drop down is in A1 and you want the choice selected in A1 to
display in B1:
in B1, enter the folowing formula:

=A1

Now B1 will always show the exact same thing in A1.......EXCEPT.........if
A1 is blank, then B1 will show 0 (zero). If you want B1 to appear blank as
well then use the following formula:

=if(A1="","",A1)

Also, B1 will automatically change every time A1 is changed.

HTH,

Conan




"lrb" wrote in message
...
I'm NOT proficient at Excel to say the least ... I have created a dropdown
box and want the choice selected in that cell to be pasted into another
cell
within the same worksheet automatically. Is this possible? Can you
explain
in VERY simple steps? Thank you!




  #5   Report Post  
Old December 12th 07, 07:53 PM posted to microsoft.public.excel.misc
lrb lrb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 4
Default Need to link dropdown box choice to another cell

Hi Conan,

Ok ~ I figured out my other question and have found the way to have an
absolute formula copy. The result of the formula raises another question ~
it is formatted strangely. The cell that contains the formula uses a blue
underlined font rather than how I orginally had the cell formatted. Is there
a way to change that?

Thanks again!

"Conan Kelly" wrote:

lrb,

You can just use a formula to refer to the cell with the dropdown.

Lets say your drop down is in A1 and you want the choice selected in A1 to
display in B1:
in B1, enter the folowing formula:

=A1

Now B1 will always show the exact same thing in A1.......EXCEPT.........if
A1 is blank, then B1 will show 0 (zero). If you want B1 to appear blank as
well then use the following formula:

=if(A1="","",A1)

Also, B1 will automatically change every time A1 is changed.

HTH,

Conan




"lrb" wrote in message
...
I'm NOT proficient at Excel to say the least ... I have created a dropdown
box and want the choice selected in that cell to be pasted into another
cell
within the same worksheet automatically. Is this possible? Can you
explain
in VERY simple steps? Thank you!






  #6   Report Post  
Old December 12th 07, 07:55 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 419
Default Need to link dropdown box choice to another cell

irb,

In the formula I posted, the cell reference is relative....means the
references will change when you copy/paste. You just need to make them
absolute.......they won't change when you copy/paste.

To do that, put dollar signs before both the column letter and the row
number. For example: "=A1" will become "=$A$1";"=if(A1="","",A1)" will
become "=if($A$1="","",$A$1)"

Look up relative/absolute cell references in XL's Help for more info.

HTH,

Conan





"lrb" wrote in message
...
Thank you Conan ~ that's exactly what I needed. One more question ... I
tried to copy and paste to the following rows and the formula was
automatically changed from A1 to A2, A3, etc. How can I keep the formula
a
constant when copying?

"Conan Kelly" wrote:

lrb,

You can just use a formula to refer to the cell with the dropdown.

Lets say your drop down is in A1 and you want the choice selected in A1
to
display in B1:
in B1, enter the folowing formula:

=A1

Now B1 will always show the exact same thing in
A1.......EXCEPT.........if
A1 is blank, then B1 will show 0 (zero). If you want B1 to appear blank
as
well then use the following formula:

=if(A1="","",A1)

Also, B1 will automatically change every time A1 is changed.

HTH,

Conan




"lrb" wrote in message
...
I'm NOT proficient at Excel to say the least ... I have created a
dropdown
box and want the choice selected in that cell to be pasted into another
cell
within the same worksheet automatically. Is this possible? Can you
explain
in VERY simple steps? Thank you!






  #7   Report Post  
Old December 12th 07, 08:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 419
Default Need to link dropdown box choice to another cell

It sounds like the cell has hyperlink formatting. Was there a hyperlink in
this cell before?

Yeah, just change the color of the font and remove underlining:

Format Cells... Font tab

You can change both color and underlining from here.


"lrb" wrote in message
...
Hi Conan,

Ok ~ I figured out my other question and have found the way to have an
absolute formula copy. The result of the formula raises another question
~
it is formatted strangely. The cell that contains the formula uses a blue
underlined font rather than how I orginally had the cell formatted. Is
there
a way to change that?

Thanks again!

"Conan Kelly" wrote:

lrb,

You can just use a formula to refer to the cell with the dropdown.

Lets say your drop down is in A1 and you want the choice selected in A1
to
display in B1:
in B1, enter the folowing formula:

=A1

Now B1 will always show the exact same thing in
A1.......EXCEPT.........if
A1 is blank, then B1 will show 0 (zero). If you want B1 to appear blank
as
well then use the following formula:

=if(A1="","",A1)

Also, B1 will automatically change every time A1 is changed.

HTH,

Conan




"lrb" wrote in message
...
I'm NOT proficient at Excel to say the least ... I have created a
dropdown
box and want the choice selected in that cell to be pasted into another
cell
within the same worksheet automatically. Is this possible? Can you
explain
in VERY simple steps? Thank you!








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple choice in dropdown list Augusta Excel Discussion (Misc queries) 1 October 19th 07 10:16 AM
How do I get a worksheet to link to a dropdown menu? Lorie Excel Discussion (Misc queries) 1 May 14th 06 03:01 PM
VBA code to open dropdown box(s) in XL, permit a choice, then resu Dennis Excel Discussion (Misc queries) 0 February 26th 06 06:15 PM
Dropdown list/Multiple choice?? KDD Excel Discussion (Misc queries) 2 August 30th 05 09:28 AM
HOW TO GET DROPDOWN LIST TO LINK TO OTHER CELLS? Vic Excel Discussion (Misc queries) 1 April 20th 05 01:59 PM


All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017