Solved: return value on column selection

[san_son]

Hi everyone

I wanna know how to code an application where i have a hidden sheet and link it to some other sheet whereby user can select the item and rest of the things are automatically filled up. i am attaching a sample , just exactly like this one .

[Bob Phillips]

A different approach, don't let them make mistakes

[Bob Phillips]

Forgot the file

[san_son]

THANKS A TON , ANYWAY YOU JUST UNLOCKED THE PASSWORD OR WHAT

[Bob Phillips]

Sorry, what do you mean?

[san_son]

Sorry , Nothing i just wanna ask you , weather you recoded the file or you just broke the password .

[rory]

The password is blank, so it's not hard to unprotect!

[Bob Phillips]

Sorry , Nothing i just wanna ask you , weather you recoded the file or you just broke the password .

There was no password so there was nothing to break. Not a good idea to post a password protected workbook when asking for help.

[san_son]

SORRY BUT I GOT THAT FROM SOME FRIENDS , AND I AM JUST A NEWBIE.

[Bob Phillips]

Got what, the code? Did you not know how to unprotect it then?

BTW, does my suggestion solve it for you?

[san_son]

yeah , thanks a lot , you have definately helped me solve that problem .

yes i got that file from some one . i think we shld not waste time discussing this useless thing ..

and again thanks a lot ....

Regards