| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells = Worksheet name
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying worksheet cells into another worksheet using autofill | Excel Discussion (Misc queries) | |||
| CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| linking cells in one worksheet to cells in another worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
![Jako[_79_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
