Hello everyone,
First post here
I have used Excel I think like a lot of people for a long time and I am know stuck with a stupid problem.
Indeed in my spreadsheet I want to give to users the possibility to choose a "product name" in a list (let's say the choice can be made in every row of column A), this list is generated with a "product chart" I have in the same tab. The user does not have access to this chart, he just choose in the list of column A what product he is selling.
Depending of the choice made in column A, row 1 for example I want to have other cells of the row 1 filled out.
These other cells have to be filled according to the choice made in column A (info is in the product chart, on the same row that the product name clicked in column A).
Before I was not annoyed because I used very small charts (few products) bu now I have about 200 products in my chart, so I cannot continue with: if (A1=xxxxx,B1 =yyyyy,"")
If anyone has an answer it will be deeply appreciated.
Precision: I have MAC 2008, so I don't have VBA
Bye !
Bookmarks