Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to insert the worksheet name into a cell?
I have MS Office Excel 2003.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to insert the worksheet name into a cell?
Your question isn't clear. do you mean to transffer data from Microsfot
works to Microsoft Excel? I dont havve worrks, but check if you can save the file in .CSV format (commar seperated values). then in excel use data - Import External data. On the 1st menu selectt delimited On the 2nd menu select Delimiters comma " wrote: I have MS Office Excel 2003. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to insert the worksheet name into a cell?
See Debra Dalgleish's site:
http://contextures.com/xlfaqFun.html#SheetName wrote: I have MS Office Excel 2003. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to insert the worksheet name into a cell?
Dave Peterson wrote...
See Debra Dalgleish's site: http://contextures.com/xlfaqFun.html#SheetName .... If OP has Excel 2003 and would never be sharing files with users of Excel 2000 and prior, there's also XLM. Define WSN as =GET.WORKBOOK(38). Warning: copying formulas containing names that call XLM functions in their definitions and pasting into other worksheets will ALWAYS crash Excel 2000 and prior with complete data loss. The advantage of GET.DOCUMENT vs CELL("Filename",...) is that the former works whether the file has been saved or not. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
How do I insert the filename of the worksheet into a cell? | Excel Discussion (Misc queries) | |||
How to insert line on other worksheet depending upon result in cell? | Excel Discussion (Misc queries) | |||
How do I insert the filename to a specific cell of the worksheet? | Excel Discussion (Misc queries) | |||
How Do I insert the Worksheet Name in Cell A1 ? | Excel Discussion (Misc queries) |