Is there away to do this....?

[ryan.fitzpatrick3]

I have an excel workbook with 100 sheets of information. All sheets
are identical in columns and data in each column. Is there away to
pull information from all of the sheets onto one? each sheet has an
item # and a volume and total spend. What I would like to do is do a
rank function where it'll look at all items on all sheets and find the
one that has the most spend or most volume and rank it from there. Is
that possible?

Ryan

 

[Jim Thomlinson]

Ron covers a bunch of this kind of stuff on his site. Check out this link
under Copy / Paste / Merge...

http://www.rondebruin.nl/tips.htm

 

[ryan.fitzpatrick3]

Thanks, I went to his website and copy and pasted code, but it didn't
work so I just copied all of my data onto his example workbook and
that worked and renamed that workbook to mine! Thanks.

 

[Ron de Bruin]

I think you forgot this

Note: This example use the function LastRow
See the function on the bottom of the page
http://www.rondebruin.nl/copy2.htm