Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert text in a formula
I have an excel-file with a lot of sheets named ADB, AS, BM etc.
In the first sheet I'm collecting data from the sheets above. In this sheet the first collumn contains the names of the sheets in the file. In the next collumn I'm going to show data from the other sheets. For instance I use the command =ADB!A5. Is it possible to get the 'ADB' from the first collumn, so I can copy the formula????? I'm thinking of something like this: =A2!A5 (where A2 contains the text 'ADB'). T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is away to insert a "formula" into a text? | New Users to Excel | |||
Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) | |||
How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
How to insert easily the text of a scientific formula | Excel Discussion (Misc queries) | |||
How do I set up a formula to insert text in excel? | Excel Discussion (Misc queries) |