Copy data from unlocked cells

F

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?
 
D

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?
 
D

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top