Thank you. I can see what it does now and Test 2 appears to be the closest to
what i need...what code do i need to replace in order to tailor it for my
specific worksheets?

"Ron de Bruin" wrote:

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