I have a problem.

I am trying to set up an automated spreadsheet.

In the middle of the automation i need to check a series of rows to
find a particular cell value. This value is user defined before the
automation cracks in. how can i best check the data. once it is
located in the sheet i will then write a macro to copy and paste this
data and place it somewhere else.

Is anybocy up for this challenge?