Do you mean that you want to select specific records on one sheet and when
selected, have the selected record copied to another workbook? Perhaps you
could try putting your question in steps as if you were doing what you want
to achieve manually like the following example.

Select date (or whatever) in workbook 1.
Copy entrire row at selected cell.
Paste into another workbook.

--
Regards,

OssieMac


" wrote:

I am not sure what is the best way to go about this but here it goes.

I have a spreadsheet that has 108 columns of data A:DD. Each row is
a "Cycle" from the machine and the data parameters are in the
columns. The first two columns are A the date and time the cycle
started and B the cycle number. What I want is in another work book a
defined name that includes both A and B.

i.e. "9/08/07 12:43:23 PM 67543" (67543 is the batch number)

If that is not possible then is there a way when I scroll through the
date range the cell beside that shows the cycle number?

Once I have that I want to click a button and it would populate the
sheet with all of parameters from the cycle.

Basically what I want is a selectable Information sheet on each run.

Hopefully that makes sense.

Please let me know.