Dear All,
Can somebody help me out in generating a macro for forming a "n x n" matrix based on user inputs. - Excel sheet enclosed. Send me ur replies to reachspk@gmail.com![]()
Inputs:
i j Value
1 2 1
1 3 1
1 4 -1
1 8 -1
2 1 1
2 4 1
2 5 -1
2 6 -1
3 5 1
3 6 1
3 7 -1
4 1 130.1459226
4 4 -160.8272092
4 2 -144.5355421
5 2 144.5355421
5 3 -183.6928125
6 2 144.5355421
6 4 160.8272092
6 5 137.3575476
6 7 152.8315505
7 2 144.5355421
7 4 160.8272092
7 6 137.3575476
7 7 152.8315505
8 3 183.6928125
8 8 172.7183057
In remaining locations, values are zero.
i j Value
1 1 0
1 5 0 etc.,
Here, we have 8x8 matrix. But, this should be generalized for forming "n x n" matrix
Please get me an Excel Macro for this.
Thanks in advance,
Prakash
Bookmarks