Can anyone please suggest how i could do the following:

For each worksheet in my workbook if there is a value in column "B
then i want the worksheet name to appear in Column "A". There wil
however be varying numbers of rows so i imagine i need to use an xldow
/ xlup type scenario.

For example this is what i would like:

A B C D E
1 Sheet1 0000
2 Sheet1 0320
3 Sheet1 7263
4 Sheet1 2we8
5 Sheet1 hgdtw
6 Sheet1 94ir
etc.

TI

--
Message posted from http://www.ExcelForum.com