If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can one cell be autopopulated by another cell and have a drop.
I need to have cell #2 be autopopulated by cell #1 and also be able to have a
drop down menu to be able to autopopulate cell #1. If one have of the information is known but not the other I want the ability to query using either cell. |
#2
|
|||
|
|||
Hi Adrian
bit confused ... do you want ...................A.............................. B................................................. ...................C 1.........Drop down list...........value derived from drop down list..............=IF(A1="",B1,A1) the problem with this is if you put a formula in B1 which relates to the selected value in A1 if you over type it with a value (the only way i can see B1 will have a value and A1 not) then you'll lose your formula. the drop down list in A1 can be created via data / validation - check out www.contextures.com/tiptech.html for lots of ideas and if B1 you can use some sort of formula depending on how it is related to A1. Hope this gives you some ideas Cheers JulieD "Adrian" wrote in message ... I need to have cell #2 be autopopulated by cell #1 and also be able to have a drop down menu to be able to autopopulate cell #1. If one have of the information is known but not the other I want the ability to query using either cell. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
Creating a Price calculator | mariekevink | New Users | 2 | September 14th, 2004 05:53 PM |
Looks Like a Pivot Table But Isn't... | MCorrea | Worksheet Functions | 3 | June 9th, 2004 10:47 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
using cell contents in pathname | Don Guillett | Worksheet Functions | 7 | January 2nd, 2004 02:11 PM |