Howto: Filling in values based upon a particular cell

[Eric Tubbs]

Greetings,

Hopefully, I am posting in the correct newsgroup. I am currently working
with Excel 2002 and would like to ask for your wonderful help. Here is my
situation and hopefully there will be a solution to my problem.

I am currently learning how to design databases (using Access 2002) and have
decided to use Excel as a documenting tool and a template for database
tables (because I dont have the money to go out and purchase an expensive
software program). I have already made quite a nice looking template so far
and would like to reduce the chance of data entry errors.

What I would like to find out is: Is it possible to have numerous cells
changed on the fly depending on the value of a particular cell? TO
illustrate, let's say the "C" column is where everything is going to be
based on. There are numerous values that can populate this column.

Text
Memo
Number
Date
Time
Currency
Autonumber
Yes/No
OLE Object
Hyperlink

Each one of these above values has numerous properties which have their own
corresponding columns which data needs to be placed into.

For example:

If the value of C7 is "Text", then the default values for the following
columns must be:

Q7 = N/A
S7 = N/A
Y7 = No
Z7 = Yes
AA = No
AB = Yes
AC = No Control
AD = None

If the value of C7 is "Number", then the default values for the following
columns must be:

Q7 = N/A
S7 = 0
Y7 = No
Z7 = N/A
AA = No
AB = N/A
AC = N/A
AD = N/A

The rest of the values above have their own properties, but I hope you
understand my meaning, if not, please let me know. Also, if I happen to
clear out the value of C7, then all of the cell ranges should be cleared out
(emptied) of their contents.

Would this scenario have a possible solution, or will you need to see my
Excel file for more information? If I have not provided enough information,
I will be happy to supply it to you upon request.

Thanks,

Eric

P.S. I just looked at a previous posting named "automatic cell filling",
would using VLOOKUP or HLOOKUP possibly work in this instance?

 

[Biff]

Hi Eric,

Yes, the VLOOKUP() function is ideal for this situation.
You would need to create a data table that lists all the
values and their corresponding properties. Then use a
lookup formula to return the property or as you want,
leave the cell MT. It's actually very easy!

If you'd like, I can put together a sample WB and email it
to you.

Biff

 

[Eric Tubbs]

Biff,

Thanks for responding to my inquiry. Yes, I would greatly appreciate an
example if you dont mind sending one. You can send me an email to:

Eric dot Tubbs at centurytel dot net

Thanks,

Eric

 

[biff]

Will do!

-----Original Message-----
Biff,

Thanks for responding to my inquiry. Yes, I would greatly appreciate an
example if you dont mind sending one. You can send me an email to:

Eric dot Tubbs at centurytel dot net

Thanks,

Eric



.

 

[Eric Tubbs]

Biff,

Thank you for the wonderful example you sent via email. This solution should
work out just wonderful for my scenario. I appreciate you being able to help
me out.

Have a great night and take care,

Eric

 

[biff]

You're welcome!

-----Original Message-----
Biff,

Thank you for the wonderful example you sent via email. This solution should
work out just wonderful for my scenario. I appreciate you being able to help
me out.

Have a great night and take care,

Eric




.

 

[biben]

Hi Biff
I´m also surching for a solution to my database and found this in my
search.
Can you send the example to me as well I would greatly appriciate it.

to:
g_nordh at hotmail dot com

thanks
/biben