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?

On Nov 8, 9:01*pm, fuchka <fuc...@gmail.com> wrote:
> 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?

On Nov 9, 4:52*pm, Don Guillett Excel MVP <dguille...@austin.rr.com>
wrote:
> On Nov 8, 9:01*pm, fuchka <fuc...@gmail.com> wrote:> 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?

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

On Nov 10, 7:24*pm, fuchka <fuc...@gmail.com> wrote:
> On Nov 9, 4:52*pm, Don Guillett Excel MVP <dguille...@austin.rr.com>
> wrote:
>
>
>
>
>
> > On Nov 8, 9:01*pm, fuchka <fuc...@gmail.com> wrote:> 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?
>
> 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."