Default value

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:24 PM GMT

Question

QUESTION: Hi Sixth Sense I am back again with one more question for you. Can we assign a default value to a cell which can be changed by the user?

ANSWER: Yes we can. Just clarify how you would like to set the default value and what will be the default value. Whether it is for a range of cells or whole sheet cells?


---------- FOLLOW-UP ----------

QUESTION: Take this as an example. Say cell A1 has the invoice number, B1 has the invoice date and C1 has the invoice receipt date. I want to assign the default value of cell C1 to be B1 but this can be changed by the user. If this can be done then how? I would also like to know if 2 or more columns can be viewed in a single drop down list? - Raj

Answer

In C1 cell type = and refer it to B1 cell and if the user want to change it then delete the formula and input your desired date. No other go...

2 or more columns can be viewed in a single drop down list? For this what i would suggest is, just concatenate the 2 columns using Concatenate function or using =A1&B1 and use the concatenated range in your validation list.

Advertisement

©2017 eLuminary LLC. All rights reserved.