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

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

Here is a sample of sheet 1 where the data resides. This will change
periodically as the new data comes in. New data gets entered in by date and
time.

ON Sheet 2 I', looking to place the latest build number found in the data
range below

A Column B Column C Column
Date Time Error Message
6/24/2009 - 4:18 PM:
6/24/2009 - 4:18 PM: Starting System initialization, build 1010
6/24/2009 - 4:18 PM: Starting System initialization, build 1011
6/24/2009 - 4:23 PM: Loading alarm history buffer.

--
tech1NJ


"JLatham" wrote:

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

--small clarification,
I need to search for specific data on sheet 1 (last build number) and place
it on sheet 2 in cell D1. Your help is appreciated.

tech1NJ


"tech1NJ" wrote:

Here is a sample of sheet 1 where the data resides. This will change
periodically as the new data comes in. New data gets entered in by date and
time.

ON Sheet 2 I', looking to place the latest build number found in the data
range below

A Column B Column C Column
Date Time Error Message
6/24/2009 - 4:18 PM:
6/24/2009 - 4:18 PM: Starting System initialization, build 1010
6/24/2009 - 4:18 PM: Starting System initialization, build 1011
6/24/2009 - 4:23 PM: Loading alarm history buffer.

--
tech1NJ


"JLatham" wrote:

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