i have about 30 worksheets with 18 columns each and varying numbers of rows
that i need to consolidate into one worksheet in order to pivot off the data.
each worksheet has a total row that i do not need to consolidate.

i have attempted to pivot off multiple spreadsheets and couldnt get it to
function properly.

i have also attempted consolidating but the result is not what i
need...short of copying and pasting is there a simple way to consolidate the
data? thank you.

See
http://www.rondebruin.nl/copy2.htm


"se7098" schreef in bericht
...
i have about 30 worksheets with 18 columns each and varying numbers of rows
that i need to consolidate into one worksheet in order to pivot off the
data.
each worksheet has a total row that i do not need to consolidate.

i have attempted to pivot off multiple spreadsheets and couldnt get it to
function properly.

i have also attempted consolidating but the result is not what i
need...short of copying and pasting is there a simple way to consolidate
the
data? thank you.

__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Thanks Ron...i'm sure this is great information however my level of expertise
is not nearly high enough for me to understand what i need to do with this.
Thank you for trying to help me.

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/copy2.htm


"se7098" schreef in bericht
...
i have about 30 worksheets with 18 columns each and varying numbers of rows
that i need to consolidate into one worksheet in order to pivot off the
data.
each worksheet has a total row that i do not need to consolidate.

i have attempted to pivot off multiple spreadsheets and couldnt get it to
function properly.

i have also attempted consolidating but the result is not what i
need...short of copying and pasting is there a simple way to consolidate
the
data? thank you.

__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Have you download the example workbook ???

If you want I will help you to change the code for you workbook
But test the workbook first so you see what it do



"se7098" schreef in bericht
...
Thanks Ron...i'm sure this is great information however my level of
expertise
is not nearly high enough for me to understand what i need to do with
this.
Thank you for trying to help me.

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/copy2.htm


"se7098" schreef in bericht
...
i have about 30 worksheets with 18 columns each and varying numbers of
rows
that i need to consolidate into one worksheet in order to pivot off the
data.
each worksheet has a total row that i do not need to consolidate.

i have attempted to pivot off multiple spreadsheets and couldnt get it
to
function properly.

i have also attempted consolidating but the result is not what i
need...short of copying and pasting is there a simple way to
consolidate
the
data? thank you.

__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com

I attempted to run the macros in the example workbook but it would not allow
me to do so.

"Ron de Bruin" wrote:

Have you download the example workbook ???

If you want I will help you to change the code for you workbook
But test the workbook first so you see what it do



"se7098" schreef in bericht
...
Thanks Ron...i'm sure this is great information however my level of
expertise
is not nearly high enough for me to understand what i need to do with
this.
Thank you for trying to help me.

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/copy2.htm


"se7098" schreef in bericht
...
i have about 30 worksheets with 18 columns each and varying numbers of
rows
that i need to consolidate into one worksheet in order to pivot off the
data.
each worksheet has a total row that i do not need to consolidate.

i have attempted to pivot off multiple spreadsheets and couldnt get it
to
function properly.

i have also attempted consolidating but the result is not what i
need...short of copying and pasting is there a simple way to
consolidate
the
data? thank you.

__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Then your security is set to High so no code will run

ToolsMacroSecurity

Change it there





"se7098" schreef in bericht
...
I attempted to run the macros in the example workbook but it would not
allow
me to do so.

"Ron de Bruin" wrote:

Have you download the example workbook ???

If you want I will help you to change the code for you workbook
But test the workbook first so you see what it do



"se7098" schreef in bericht
...
Thanks Ron...i'm sure this is great information however my level of
expertise
is not nearly high enough for me to understand what i need to do with
this.
Thank you for trying to help me.

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/copy2.htm


"se7098" schreef in bericht
...
i have about 30 worksheets with 18 columns each and varying numbers
of
rows
that i need to consolidate into one worksheet in order to pivot off
the
data.
each worksheet has a total row that i do not need to consolidate.

i have attempted to pivot off multiple spreadsheets and couldnt get
it
to
function properly.

i have also attempted consolidating but the result is not what i
need...short of copying and pasting is there a simple way to
consolidate
the
data? thank you.

__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com