Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
indirect writing in cells
In cell A1 I have a value (5) In cell A2 I have the address of another cell (F5) Is it possible to write the value (5) in the celladdress in A2 (F5)? Must I use VisualBasic or is it possible to achieve this by using a formula in the worksheet? The address in A2 can change so it is possible for me to write a formula i cell F5. The value to be written in the recieving field may come from many different places so it is not possible to write "recieving" formulas, I must use a write-to technique. Regards Anders Olsson -- aolsson ------------------------------------------------------------------------ aolsson's Profile: http://www.excelforum.com/member.php...o&userid=36428 View this thread: http://www.excelforum.com/showthread...hreadid=561969 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
indirect writing in cells
aolsson wrote:
In cell A1 I have a value (5) In cell A2 I have the address of another cell (F5) Is it possible to write the value (5) in the celladdress in A2 (F5)? Must I use VisualBasic or is it possible to achieve this by using a formula in the worksheet? The address in A2 can change so it is possible for me to write a formula i cell F5. The value to be written in the recieving field may come from many different places so it is not possible to write "recieving" formulas, I must use a write-to technique. Regards Anders Olsson Hi Anders, I think you should use VBA, because in Excel there's no possibility to write a formula that write in different cell from which it is written in... So if you want to write a value in F5, you have to write in F5 or directly the value yu want or a formula to display the value, but you cannot write a formula in A2 to write a value in F5... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
indirect writing in cells
If you put F5 in cell A2, and then use
=INDIRECT(A2) this will return the value in F5 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "aolsson" wrote in message ... In cell A1 I have a value (5) In cell A2 I have the address of another cell (F5) Is it possible to write the value (5) in the celladdress in A2 (F5)? Must I use VisualBasic or is it possible to achieve this by using a formula in the worksheet? The address in A2 can change so it is possible for me to write a formula i cell F5. The value to be written in the recieving field may come from many different places so it is not possible to write "recieving" formulas, I must use a write-to technique. Regards Anders Olsson -- aolsson ------------------------------------------------------------------------ aolsson's Profile: http://www.excelforum.com/member.php...o&userid=36428 View this thread: http://www.excelforum.com/showthread...hreadid=561969 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |