I know that excel is mostly about formulas. But I do think that this problem
can be resolved using excel and the extra spreadsheets.
I have on spread sheet 1 customers name: and address: cells. I have my
customers on a drop down cell. So automatically I can pick out of a list of
people I put on sheet 2. But I also want the cell in the address line to
automatically change address everytime I change the name on my customer. Is
there a possibility that I can use sheet 2 for customers and address and then
put them in two different cells on sheet 1.
--
Thank you for your help