Solved How to show the same text valued on another cell

January 30, 2018 at 23:46:56
Specs: Windows 7
Dear,

Suppose i had kept filter on cell C3 where from cell C4 till C20 contains "A" or "B". if i select B on cell C3 then i need to show "B" on cell C1.
Kindly tell me how to do this


See More: How to show the same text valued on another cell


#1
January 31, 2018 at 11:08:49
✔ Best Answer
I'm confused.

What do you mean by "kept filter on cell C3"? Do you mean a Data Validation drop down list?

If so, what does C4:C20 have to do with this? If you are selecting a value in C3 and you want C1 to show the same value, why not just put this formula in C1?

=C3

What am I missing?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Report •
Related Solutions


Ask Question