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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to use sheet's name as variable
One way:
A1: <client code D1: =INDIRECT("'" & A1 & "'!D9") In article , tibby wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to use sheet's name as variable
=MID(CELL("filename"),(FIND("]",CELL("filename"))+1),50)
This will extract the name of the sheet. "tibby" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to use sheet's name as variable
Thanks guys ...
it worked "tibby" wrote: 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 |
Reply |
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 |