Copy data from unlocked cells

  • Thread starter Thread starter fuchka
  • Start date Start date
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?
 
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?
Click to expand...
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")- Hidequoted text -

- Show quoted text -
Click to expand...

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