extract selected cases in a new excell sheet

[geom06005]

Dear all

I selected the values i wanted from the select cases utility but what i want is to extract only the selected cells in a new sheet and delete all the others. Does anyone know how can i do it?

And another question. I have 30 excell files and i would like to create one excell file that will contain all the files.Any suggestions?

Many thanks

[DigDB Support]

geom06005 wrote:

I selected the values i wanted from the select cases utility but what i want is to extract only the selected cells in a new sheet and delete all the others. Does anyone know how can i do it?

After you selected the cells, you can just copy it and paste to a new sheet. This will extract the selected cells. Or, after the cells are selected, you can use Excel->DigDB->Selection->Copy Cells into->One Column

geom06005 wrote:

And another question. I have 30 excell files and i would like to create one excell file that will contain all the files.Any suggestions?

Maybe this one: http://www.digdb.com/excel_add_ins/combine_append_tables_sheets_files/ scroll to "Combine Multiple Excel Files into a Master Table" - the screenshot needs an update, the function is under "DigDB->File->Combine files..."