Below should work, sometimes it might give a duplicate value. For refreshing, you can press F9 key. If you need auto-refresh VBA code needs to be written for that as far as I know. You can refer to the below 2 links:
| F | G |
---|
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
A | | |
B | | |
C | | |
D | | |
E | | |
F | | |
G | | |
H | | |
I | | |
J | | |
K | | |
L | | |
M | | |
N | | |
O | | |
P | | |
Q | | |
R | | |
S | | |
T | | |
U | | |
V | | |
W | | |
X | | |
Y | | |
Z | | |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]13[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"]14[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: center"]17[/TD]
[TD="align: right"]17[/TD]
[TD="align: center"]18[/TD]
[TD="align: right"]18[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"]19[/TD]
[TD="align: center"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: center"]21[/TD]
[TD="align: right"]21[/TD]
[TD="align: center"]22[/TD]
[TD="align: right"]22[/TD]
[TD="align: center"]23[/TD]
[TD="align: right"]23[/TD]
[TD="align: center"]24[/TD]
[TD="align: right"]24[/TD]
[TD="align: center"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: center"]26[/TD]
[TD="align: right"]26[/TD]
[TD="align: center"]27[/TD]
[TD="align: right"]27[/TD]
[TD="align: center"]28[/TD]
[TD="align: right"]28[/TD]
[TD="align: center"]29[/TD]
[TD="align: right"]29[/TD]
[TD="align: center"]30[/TD]
[TD="align: right"]30[/TD]
[TD="align: center"]31[/TD]
[TD="align: right"]31[/TD]
[TD="align: center"]32[/TD]
[TD="align: right"]32[/TD]
[TD="align: center"]33[/TD]
[TD="align: right"]33[/TD]
[TD="align: center"]34[/TD]
[TD="align: right"]34[/TD]
[TD="align: center"]35[/TD]
[TD="align: right"]35[/TD]
</tbody>