Defined names
 

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.

Defined names
 

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.

Defined names
 

1. Select date /cycle number using a scroll down list in workbook A
for the cycle data in workbook B (it is possible to have many cycles
in one day so I need the ability to select by both)
2. click button "get cycle data"
3. Info from Workbook B A?:DD? is copied into workbookA

Defined names
 

I really cannot understand what it is you want. What do you mean by "using a
scroll down list in workbook A"? Do you mean that you want the date and cycle
number from Workbook B to be in a combo box and you want the ability to copy
selected data from Workbook B to workbook A so that workbook A only contains
samples (as selected) of data from workbook B?

--
Regards,

OssieMac


" wrote:

1. Select date /cycle number using a scroll down list in workbook A
for the cycle data in workbook B (it is possible to have many cycles
in one day so I need the ability to select by both)
2. click button "get cycle data"
3. Info from Workbook B A?:DD? is copied into workbookA

Defined names
 

OssieMac

What I am using right now is this. I have a defined name of all the
cycle numbers (this comes from work book B) in workbook A
I used validation, list and made one of the cells in WorkBook A Sheet1
equal the defined name. The user can then scroll through the list of
cycle numbers. Once they find the cycle number the user must click a
button which uses a macro that finds the specific cycle number in
workbook B and pastes Columns A?:DD? into workbook A.

I do not want to scroll through just the cycle number; I need to be
able to scroll through the date and cycle number.

So when they click on the scroll down list they would see:

09/25/08 56738
09/25/08 56473
09/27/08 67482

I have no idea how else I can explain it
I apologize if I am not making much sense.....