i have a dropdown list with one formula and a few constants, now i need to copy the list to entire column and wen i do so, the formula in drop down list needs to take values from corresponding cell and give different value in each row. i guess i need to set a range or something.
hope i am clear
please help asap
Hi, niyatir27,
remove the last line you entered without Data/Validation. Then go to Ribbon Edit and insert a List (with headers). From then on you will find the formulae and Data/Validation in each new entry line you have if you either use the Tabulator to advance or set the cursor movement to right in the options..
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
m sorry, i ddnt understand... please walk me through it
will be grateful
Hi, niyatir27,
maybe have a look at the attached workbook instead of me trying to explain.
Ciao,
Holger
i have done some editting in the file attached. what i require is column C's value in the dropdown list at column D.
as in C1's value in D1's list, C2's value in list at D2 and so on. i have added the list using data validation and values in list are-
problem!C2
10
7
15
20
hey holger,
i need column c's value in column D's list, that is my problem actually.
help
Hi, niyatir27,
I really donīt know if itīs possible with formulas - I only know how to code it in VBA.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks