I'm in a bit of a pickle (as I'm sure most people making requests here are),
Thus far about 8hrs of tutorials has
passed by, and this is the last project I want gnawing on my time during the Christmas holidays.
I happen to be an
owner of a very ugly customer spreadsheet. Due to the nature of the information, there will always be large blank holes,
missing data, or old data that shouldn't be removed.
The spreadsheet is layed out as such:
(I will use cars & houses as examples to hopefuly make it clearer)
Column A : List of client names
Column B : denotes the status of the client's data regarding their car: up to
date, old, or none available
Column C-F : Attributes of the client's car (colour, model, etc.)
: denotes the status of the client's data regarding their house: up to date, old, or empty
Column H-k :
Attributes of the client's house (bedrooms, mortgage, etc.)
Sometimes a client has more than one car or house, which so far takes up an extra line of entry one
line below. This results in the clients list containing blank spaces.
Sometimes a client doesn't own a car or a
I'm trying to configure this setup in such a way that if I select a particular client from drop down menu
(such as data validation lists), their information will be displayed along side it.
So if I selected client
'Chuck' from the client list, I would see only information pertinent to his car / house.
I hope to find a solution
And innumerable thanks to anyone that took interest and read this far.