Consolidating sheets

Perhaps something like this, Andy?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


<Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
> Hi
>
> We are buying a company and I need to create a stock spreadsheet from
their
> workbook. I would like a single sheet containing the information from
about
> 25 of their sheets. They have one sheet per type of stock item (all in one
> book), so some of their sheets have 1 row and some have 50! Bearing in
mind
> that some of the rows are hidden (which I don't want) what is the easiest
> way to consolidate their information into a single sheet, containing all
of
> the info from the individual sheets?
> Cheers.
> Andy.
>
>

Thanks, Anne. I'll give it a go!

Andy.

"Anne Troy" <ng@officearticles.com> wrote in message
news:9e237$42cd7efc$97c5108d$11061@allthenewsgroups.com...
> Perhaps something like this, Andy?
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=151
>
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> <Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
>> Hi
>>
>> We are buying a company and I need to create a stock spreadsheet from
> their
>> workbook. I would like a single sheet containing the information from
> about
>> 25 of their sheets. They have one sheet per type of stock item (all in
>> one
>> book), so some of their sheets have 1 row and some have 50! Bearing in
> mind
>> that some of the rows are hidden (which I don't want) what is the easiest
>> way to consolidate their information into a single sheet, containing all
> of
>> the info from the individual sheets?
>> Cheers.
>> Andy.
>>
>>
>
>

Hi

I've tried that but it includes the hidden rows - which I don't want! Andy
ideas?

Andy.

<Andy> wrote in message news:uKQl6jygFHA.2632@TK2MSFTNGP09.phx.gbl...
> Thanks, Anne. I'll give it a go!
>
> Andy.
>
> "Anne Troy" <ng@officearticles.com> wrote in message
> news:9e237$42cd7efc$97c5108d$11061@allthenewsgroups.com...
>> Perhaps something like this, Andy?
>> http://www.vbaexpress.com/kb/getarticle.php?kb_id=151
>>
>> *******************
>> ~Anne Troy
>>
>> www.OfficeArticles.com
>> www.MyExpertsOnline.com
>>
>>
>> <Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
>>> Hi
>>>
>>> We are buying a company and I need to create a stock spreadsheet from
>> their
>>> workbook. I would like a single sheet containing the information from
>> about
>>> 25 of their sheets. They have one sheet per type of stock item (all in
>>> one
>>> book), so some of their sheets have 1 row and some have 50! Bearing in
>> mind
>>> that some of the rows are hidden (which I don't want) what is the
>>> easiest
>>> way to consolidate their information into a single sheet, containing all
>> of
>>> the info from the individual sheets?
>>> Cheers.
>>> Andy.
>>>
>>>
>>
>>
>
>

Perhaps something like this, Andy?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


<Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
> Hi
>
> We are buying a company and I need to create a stock spreadsheet from
their
> workbook. I would like a single sheet containing the information from
about
> 25 of their sheets. They have one sheet per type of stock item (all in one
> book), so some of their sheets have 1 row and some have 50! Bearing in
mind
> that some of the rows are hidden (which I don't want) what is the easiest
> way to consolidate their information into a single sheet, containing all
of
> the info from the individual sheets?
> Cheers.
> Andy.
>
>

Thanks, Anne. I'll give it a go!

Andy.

"Anne Troy" <ng@officearticles.com> wrote in message
news:9e237$42cd7efc$97c5108d$11061@allthenewsgroups.com...
> Perhaps something like this, Andy?
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=151
>
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> <Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
>> Hi
>>
>> We are buying a company and I need to create a stock spreadsheet from
> their
>> workbook. I would like a single sheet containing the information from
> about
>> 25 of their sheets. They have one sheet per type of stock item (all in
>> one
>> book), so some of their sheets have 1 row and some have 50! Bearing in
> mind
>> that some of the rows are hidden (which I don't want) what is the easiest
>> way to consolidate their information into a single sheet, containing all
> of
>> the info from the individual sheets?
>> Cheers.
>> Andy.
>>
>>
>
>

Hi

I've tried that but it includes the hidden rows - which I don't want! Andy
ideas?

Andy.

<Andy> wrote in message news:uKQl6jygFHA.2632@TK2MSFTNGP09.phx.gbl...
> Thanks, Anne. I'll give it a go!
>
> Andy.
>
> "Anne Troy" <ng@officearticles.com> wrote in message
> news:9e237$42cd7efc$97c5108d$11061@allthenewsgroups.com...
>> Perhaps something like this, Andy?
>> http://www.vbaexpress.com/kb/getarticle.php?kb_id=151
>>
>> *******************
>> ~Anne Troy
>>
>> www.OfficeArticles.com
>> www.MyExpertsOnline.com
>>
>>
>> <Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
>>> Hi
>>>
>>> We are buying a company and I need to create a stock spreadsheet from
>> their
>>> workbook. I would like a single sheet containing the information from
>> about
>>> 25 of their sheets. They have one sheet per type of stock item (all in
>>> one
>>> book), so some of their sheets have 1 row and some have 50! Bearing in
>> mind
>>> that some of the rows are hidden (which I don't want) what is the
>>> easiest
>>> way to consolidate their information into a single sheet, containing all
>> of
>>> the info from the individual sheets?
>>> Cheers.
>>> Andy.
>>>
>>>
>>
>>
>
>

Hi

We are buying a company and I need to create a stock spreadsheet from their
workbook. I would like a single sheet containing the information from about
25 of their sheets. They have one sheet per type of stock item (all in one
book), so some of their sheets have 1 row and some have 50! Bearing in mind
that some of the rows are hidden (which I don't want) what is the easiest
way to consolidate their information into a single sheet, containing all of
the info from the individual sheets?
Cheers.
Andy.

Perhaps something like this, Andy?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


<Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
> Hi
>
> We are buying a company and I need to create a stock spreadsheet from
their
> workbook. I would like a single sheet containing the information from
about
> 25 of their sheets. They have one sheet per type of stock item (all in one
> book), so some of their sheets have 1 row and some have 50! Bearing in
mind
> that some of the rows are hidden (which I don't want) what is the easiest
> way to consolidate their information into a single sheet, containing all
of
> the info from the individual sheets?
> Cheers.
> Andy.
>
>

Thanks, Anne. I'll give it a go!

Andy.

"Anne Troy" <ng@officearticles.com> wrote in message
news:9e237$42cd7efc$97c5108d$11061@allthenewsgroups.com...
> Perhaps something like this, Andy?
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=151
>
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> <Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
>> Hi
>>
>> We are buying a company and I need to create a stock spreadsheet from
> their
>> workbook. I would like a single sheet containing the information from
> about
>> 25 of their sheets. They have one sheet per type of stock item (all in
>> one
>> book), so some of their sheets have 1 row and some have 50! Bearing in
> mind
>> that some of the rows are hidden (which I don't want) what is the easiest
>> way to consolidate their information into a single sheet, containing all
> of
>> the info from the individual sheets?
>> Cheers.
>> Andy.
>>
>>
>
>

Hi

I've tried that but it includes the hidden rows - which I don't want! Andy
ideas?

Andy.

<Andy> wrote in message news:uKQl6jygFHA.2632@TK2MSFTNGP09.phx.gbl...
> Thanks, Anne. I'll give it a go!
>
> Andy.
>
> "Anne Troy" <ng@officearticles.com> wrote in message
> news:9e237$42cd7efc$97c5108d$11061@allthenewsgroups.com...
>> Perhaps something like this, Andy?
>> http://www.vbaexpress.com/kb/getarticle.php?kb_id=151
>>
>> *******************
>> ~Anne Troy
>>
>> www.OfficeArticles.com
>> www.MyExpertsOnline.com
>>
>>
>> <Andy> wrote in message news:eiDy1YygFHA.3912@tk2msftngp13.phx.gbl...
>>> Hi
>>>
>>> We are buying a company and I need to create a stock spreadsheet from
>> their
>>> workbook. I would like a single sheet containing the information from
>> about
>>> 25 of their sheets. They have one sheet per type of stock item (all in
>>> one
>>> book), so some of their sheets have 1 row and some have 50! Bearing in
>> mind
>>> that some of the rows are hidden (which I don't want) what is the
>>> easiest
>>> way to consolidate their information into a single sheet, containing all
>> of
>>> the info from the individual sheets?
>>> Cheers.
>>> Andy.
>>>
>>>
>>
>>
>
>