change automatically the cell reference

[anetanaro]

Hi All,
I am new in this forum. I hope you will help me solve my problem.

I would like to change automatically the cell reference (like in the attached document).


alway in the next column i want to increse the cell reference by one !$C$10

Cell H8=+'Report (USD)'!$C$10
Cell I8=+'Report (USD)'!$C$11
Cell J8=+'Report (USD)'!$C$12
Cell K8=+'Report (USD)'!$C$13

etc... etc...

What form to use here that i can apply to more than 1 thousends colums in the sale row?

Additionally I need to do the same excercise for the columns !$C$10

Cell H8=+'Report (USD)'!$C$10
Cell H9=+'Report (USD)'!$D$10
Cell H10=+'Report (USD)'!$E$10
Cell H11=+'Report (USD)'!$F$10

Thank you!!!

[Aardigspook]

You can do this using Indirect combined with Column() (for dragging across) and Row() (for dragging down).
This in H8 dragged across will increment the row numbers:

Please Login or Register  to view this content.

This in H8 dragged down will increment the column numbers:

Please Login or Register  to view this content.

So, since you want to do both, use this combination in H8, which you can then drag across and down:

Please Login or Register  to view this content.

However, in this case, since you want to drag columns down rows and rows across columns, is there any reason why you can't swap your rows for columns? That way you could just drag down to increase the rows and drag across to increase the columns, without any need for using Indirect with Row/Column at all.


Edit: here are the formulae in German, from this site: https://en.excel-translator.de/translator/

Please Login or Register  to view this content.