Fill down number in bracket (1 Viewer)

[Kyp]

In a column, I have the following text. MNET_1.WriteData[1]
I need to fill down to MNET_1.WriteData[960]

Selecting and dragging down does not increase the bracketed number, nor does adding 1 to the previous cell.
Not wanting to manually enter all the number, is there any way to accomplish this automatically?

Cheers!

 

[Gasman]

Use

="MNET_1.writedata[" & ROW() & "]"

 

[Kyp]

Use

="MNET_1.writedata[" & ROW() & "]"

@Gasman
Thanks for the reply!
I will add the starting row# to the formula and that should work!
MNET_1.writedata section is way down on row 854. I have the readdata above the writedata.

Cheers!

 

[KitaYama]

Selecting and dragging down does not increase the bracketed number,

It does. If I understand your question correctly.
right click the point at the bottom right edge of the cell and drop down. Then select series from the list.

 

[Kyp]

@KitaYama
I've tried that multiple times. For some reason, dragging the handle down does not increment the bracketed number.
Would not even give me the option to select "Fill Series". However, I was able to get what I needed from the post by @Gasman

Thank you for the early morning reply!
Hope you have a great day!

Cheers!

 

[KitaYama]

ould not even give me the option to select "Fill Series".

Right drag and left drag have different roles.
Did you drag the handle with right button of your mouse?

 

[KitaYama]

Here's another way to fill series :

In a cell type : MNET_1.WriteData[1]
In a cell bellow that type : MNET_1.WriteData[2]

Now select your second cell and left drag the handle down.
Excel understands you want to fill series

 

[Gasman]

Dragging or double clicking the bottom right corner does increment the value, however for that to work at any time, there has to be data in the adjacent cell to the left?

 

[KitaYama]

there has to be data in the adjacent cell to the left

No, there's no independency to adjacent cells.
You can test it in an all blank sheet. In a blank sheet, type a value in a cell and right drag cell's handle to fill series.