| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two lines of text to create tab name and use with Indirect
I apologize if this has been asked/answered -- I couldn't find this problem
elsewhere. Tabs are named "Jan In", "Jan Out", "Jan Static", "Feb In", "Feb Out", "Feb Static", etc. B1 & C1 contain text (Jan, Feb) A2, A3, and A4 also contain text (In, Out, Static) How can I combine B1 & A2 to use data from the "Jan In" worksheet in a formula? I've tried using ONCATENATE and INDIRECT, but either I'm missing something...or there is a different solution. -- cp |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two lines of text to create tab name and use with Indirect
Hi
The general idea =INDIRECT("'"&B1&" "&A2&"'!A1") be careful with the singe and double quotes -- If this helps, please click the Yes button Cheers, Shane Devenshire "cp" wrote: I apologize if this has been asked/answered -- I couldn't find this problem elsewhere. Tabs are named "Jan In", "Jan Out", "Jan Static", "Feb In", "Feb Out", "Feb Static", etc. B1 & C1 contain text (Jan, Feb) A2, A3, and A4 also contain text (In, Out, Static) How can I combine B1 & A2 to use data from the "Jan In" worksheet in a formula? I've tried using ONCATENATE and INDIRECT, but either I'm missing something...or there is a different solution. -- cp |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two lines of text to create tab name and use with Indirect
Jeez, eh? I was trying to make it MUCH more difficult! Thanks so much!
"Shane Devenshire" wrote: Hi The general idea =INDIRECT("'"&B1&" "&A2&"'!A1") be careful with the singe and double quotes -- If this helps, please click the Yes button Cheers, Shane Devenshire "cp" wrote: I apologize if this has been asked/answered -- I couldn't find this problem elsewhere. Tabs are named "Jan In", "Jan Out", "Jan Static", "Feb In", "Feb Out", "Feb Static", etc. B1 & C1 contain text (Jan, Feb) A2, A3, and A4 also contain text (In, Out, Static) How can I combine B1 & A2 to use data from the "Jan In" worksheet in a formula? I've tried using ONCATENATE and INDIRECT, but either I'm missing something...or there is a different solution. -- cp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create two lines in one cell | Excel Worksheet Functions | |||
| How to create several lines in one cell? | Excel Discussion (Misc queries) | |||
| How do I create a chart on two axes with two lines and a bar | Charts and Charting in Excel | |||
| I have doubts about Create Lines Charts | Charts and Charting in Excel | |||
| How do you create or set up time lines | Charts and Charting in Excel | |||
Linear Mode
