I have several worksheets in a workbook that I would like to combine
onto one. All the column titles are the same, but the rows may
change.

Please see the attached example. I would like to know how to make the
"All tab" automatic, since the ranges may change from day to day.

The if possible I would like to make a consolidated tab based on a
criteria.

Thanks!!!


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4564 |
+-------------------------------------------------------------------+

--
Ninjafer
------------------------------------------------------------------------
Ninjafer's Profile: http://www.excelforum.com/member.php...o&userid=24711
View this thread: http://www.excelforum.com/showthread...hreadid=528938