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.