moving rows automatedly

**jay28mtx** · 04-03-2012, 01:41 PM

hello. im currently working on a company spread sheet and am trying to automate the process a bit.
a b c d e f
1 san antonio 1111111 joe blow 123 main steet san antonio tx
2 austin 1111112 joe blow 123 main steet san antonio tx
3 corpus 1111134 joe blow 123 main steet san antonio tx
4 san antonio 1111156 joe blow 123 main steet san antonio tx

i would like to look at row "A" and identify a specific city, and if city is found, i want the whole row to be pulled over to another row altogether. i cant seem to figure it out. i would be very appreciative of any help i can receive. the best i can come up with is:

=IF(Sheet1!$A$2:$A$1104="valley",$A$2:$Q$1104=Sheet1!A3:Q953)

im refernecing another part of the worksheet so i can pull infofrom there straight to my workable cells. anyone have any ideas?

**dilipandey** · 04-03-2012, 01:53 PM

Hi jay,

Welcome to the forum.

=IF(Sheet1!$A$2:$A$1104="valley",$A$2:$Q$1104=Sheet1!A3:Q953)

You need to include countif function..I guess.

type below in cell A3 and drag it further

=if(countif($A$2:$A$1104,"valley),sheet1!A3,"")

post the sample file if you face any challenges. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>