Hi David

One way
Apply an autofilter with DataFilterAutofilter
Use the dropdown on column C to select R
Mark the range of visible cells CutPaste to Sheet2

--
Regards

Roger Govier


"David G." wrote in message
...
Have 10+ columns of data with 100+ rows.
And in Column C there are different codes (S, R, K, X).
I would like a formula that searches the columns and finds just the R
coded
rows and then moves that "R" entire row of data to a 2nd sheet.
--
David G.