Copy cell data if give cell above is Y

Closed
stipulatinglove - Apr 7, 2010 at 02:42 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 7, 2010 at 05:52 AM


Can someone help me with this?


E1, I1, M1, Q1 = Y and U4 = not filled in

E4, I4, M4, Q4, U4 etc. = a number - for example 3

At the end I want it to auto select the cells if there is a Y above that cell.

How do I make this happen?

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 7, 2010 at 05:52 AM
auto select what cells ?
0