On Friday, October 25, 2013 4:10:19 PM UTC-4, Claus Busch wrote:
Hi,



Am Fri, 25 Oct 2013 13:07:49 -0700 (PDT) schrieb :





One more thing, in the adjacent column I would like to reference data in a specific cell from the corresponding tab. thanks again.



what do you want to have? The range address of each tab?





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

I would like to have a worksheet that lists all tabs in the workbook and also references a specific cell in each tab next to the tab name on the worksheet