| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to use sheet's name as variable
Hi,
I have a worksheet with contracts. For each contract I have a sheet which has as name the client's code. There are lots of sheets. In each sheet the structure is the same, so, for example in cell D9 in every sheet you'll find the same info regarding that client In another sheet, I want to put in a cell the client's code and to extract the info I want from the client's sheet. So I want to use the sheet's name as variable. Is there a way I can do that with a function ? Thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Sort : how can I use a variable in a VB sort function? | Excel Worksheet Functions | |||
| excel should have a function to count sheets | Excel Worksheet Functions | |||
| how do i use the function to copy and paste a determined variable. | Excel Worksheet Functions | |||
Threaded Mode
