How retreive specific data from 1st Sheet and placing it on 2nd Sh

T

tech1NJ

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.
 
J

JLatham

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!
 
T

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.
 
T

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
 
Top