Increment letter instead on number on reference on copy paste

[RobertoAlberto]

Hi,

I have two pages Page1 and Page2
on Page two I have lines with links from Page1 like:

=$page1.A1 =$page1.A2 =$page1.A3

When I copy the whole line and paste it next to it, the resulting line looks like this :

=$page1.A2 =$page1.A3 =$page1.A4

I want it to be like this instead :

=$page1.B1 =$page1.B2 =$page1.B3

How can I acheave this ? I can use $ in reference to stop incrementing the number but how to increment the letter ?

Thanks

[Lupp]

What you seem to want is called a TRANSPOSITION of a source array (cell range).
In principle there is a standard function for this kind of task, but its usage comes with disadvantages. You may better try to do it in interactive mode using PasteSpecial (Shift+Ctrl+V) with the transpose tool enabled.
More detailed advice would require to know your situation to any relevant detail.
Also see attached;
disask101882TranspositionToAdifferentSheet.ods (32.8 KB)