The attached file should enable you to select the list by Position, but
be aware, the formula in G2 to H18 are all different, but from G18:H18
can be formula-copied down as many rows as are required.

The G column is white-on-white hidden, to allow selection without
displaying repetitive data. Column H is hidden, and extends the If
statements limit of 7 to allow 14 lines of data.
(If the word 'error' appears, you will need another extension, however,
considering your data I doubt there will be any such need).

Hope this helps


Ninjafer Wrote:
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=4565 |
+-------------------------------------------------------------------+

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