have an entire row populate with a link when the data in a cell ch

  • Thread starter Thread starter ericaamousseau
  • Start date Start date
E

ericaamousseau

I do not even know how to ask this! I knwo it can be doen though. What I
want is for an entire row to populate on a worksheet when teh vaule of the
linked cell changes. For example

worksheet 1
A B C D E
1 Kris yes blue 0944 yes
2 Sam yes red 1233 no
3 Kris no white 0700 yes

what I would like is for cells A1, B1, C1, D1, and E1 to populate what is
in columns B, C, D, E only when a certain value is in cell A1 - this time
Kris.

worksheet 2
A B C D E
1 Kris yes blue 0944 yes
2
3 Kris no white 0700 yes

So kinda when A1 equals "kris" B1, C1, D1, and E1 follow with the data fromt
the other worksheet. I have seen this done, but can not figure it out.
thanks for any help!
 
Back
Top