Copy data from unlocked cells

[fuchka]

Hello

Basically, I have an excel worksheet with number of unprotected cells
containing data on various places (rows and columns) within sheet
(example: A1:A10, B13, C15, C17, A18, A20 etc.)

Is there a way to copy all the data from unlocked cells to another
sheet and sort it into row?

I will have about 15-20 excel files with filled data, and I would like
to call the data from those files from all unprotected cells in sheet
"Survey" and call the data into one excel file and sort it out in a
row.

Can anyone help?

 

[Don Guillett Excel MVP]

Hello

Basically, I have an excel worksheet with number of unprotected cells
containing data on various places (rows and columns) within sheet
(example: A1:A10, B13, C15, C17, A18, A20 etc.)

Is there a way to copy all the data from unlocked cells to another
sheet and sort it into row?

I will have about 15-20 excel files with filled data, and I would like
to call the data from those files from all unprotected cells in sheet
"Survey" and call the data into one excel file and sort it out in a
row.

Can anyone help?

Are they always the exact same cells in each file? What sheet(s). More
info?

 

[fuchka]

Are they always the exact same cells in each file? What sheet(s). More
info?

Always exact same cells in each file. One sheet (call it sheet "x")

 

[Don Guillett Excel MVP]

Always exact same cells in each file. One sheet (call it sheet "x")- Hidequoted text -

- Show quoted text -

Send your summary file and one (or more) source files so I can see
your layout

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."