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

  • Thread starter Thread starter tech1NJ
  • Start date Start date
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.
 
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!
 
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.
 
--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
 
Back
Top