Home |
Search |
Today's Posts |
#1
|
|||
|
|||
setting transferred text as constant
I have a workbook which refers to data across several sheets.
On the setup page names are entered as eg John and Smith on another page the name is concatenated to become John Smith later it is referred to as Setup!d5 and then used in a sorted table from A10 on that sheet. (all very confusing but necessary!) Is it possible to make the contents of A10 for instance a value as when the table is sorted with $s the data is taken from Setup d5 and not the sorted data!! I hope that someone understands my problem and can offer a fix? Best wishes from a wet North Yorkshire UK. Jp |
#2
|
|||
|
|||
setting transferred text as constant
From Tom Ogilvy
=Indirect("cell_address") is what I needed. Thanks Tom - now working perfectly. Tonto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Setting text as a background in cell | Excel Worksheet Functions |