worksheet function

  • Thread starter Thread starter Natarajan Sivashanmugam
  • Start date Start date
N

Natarajan Sivashanmugam

I am having some set of values in a row. In that, some of
the values will be in a particular color. Now, I want to
copy the colored values alone to another row in their
respective rows. To copy those particular values, I am
doing it cell by cell. It is a time consuming process. So,
I need a function to do this. Thanks.

1 1
2 2
3
4 4
5

In the above values 1,2 and 4 is colored and I have to
copy those values alone to another row.
 
I think that you will need to do this with a macro. I do
not think that there exists a function to do what you want.

Akshay
 
Back
Top