Need more information: are you looking for some value such as a name and want
to return another value based on the name?

What ranges are involved, and what type of data is involved?

Is the location on the second sheet always the same or will it also be
changing over time?

Sample of "before" and "after" usually helps bigtime!

"tech1NJ" wrote:

Looking to search a range of cells in Sheet1, find specific data and place it
on Sheet2. Does anyone have a way of doing this.

Range of cells in sheet one will be updated periodically and cell range will
grow with it.
--
tech1NJ