I have 2 sheets, one has totals in a row, I want those totals to fill another sheet's column.
Can this be done?
IE I have Income listed in rows, with totals for each field at the bottom of each column.
On a separate sheet (same file), I want to do a profit/loss, with fields in a column, and totals for them in a column, filled from the income sheet.
[Solved] Filling down, from another sheet's across cells
-
- Posts: 25
- Joined: Mon Nov 05, 2012 4:52 am
[Solved] Filling down, from another sheet's across cells
Last edited by robleyd on Sat Apr 13, 2024 9:26 am, edited 1 time in total.
Reason: Tagged [Solved]. Add green tick
Reason: Tagged [Solved]. Add green tick
OpenOffice 4.1.5 on Windows 10 Pro. Folk like you helping folk like me, makes the world an easier place to be.
Re: filling down, from another sheet's across cells
Hallo
enter something like:
into the top_cell of the Target_Range
enter something like:
Code: Select all
=TRANSPOSE(other_sheet.A30:Z30)
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
-
- Posts: 25
- Joined: Mon Nov 05, 2012 4:52 am
Re: Filling down, from another sheet's across cells
Doesn't work, sorry. But now I can explain better.
I have 8 rows and one column in sheet 2 I want to transpose 1 row and 8 columns from sheet 1 into sheet 2.
Can this be done?
I have 8 rows and one column in sheet 2 I want to transpose 1 row and 8 columns from sheet 1 into sheet 2.
Can this be done?
OpenOffice 4.1.5 on Windows 10 Pro. Folk like you helping folk like me, makes the world an easier place to be.
Re: Filling down, from another sheet's across cells
Is this what you want? Sheet1 is the source, Sheet2 is the transposed values.
Or this where Sheet2 is the source and Sheet1 is the transposed values.
Or this where Sheet2 is the source and Sheet1 is the transposed values.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
-
- Posts: 25
- Joined: Mon Nov 05, 2012 4:52 am
Re: Filling down, from another sheet's across cells
YES, THE 2ND ONE.
SO HOW DID YOU DO IT PLEASE? I CANNOT REPLICATE...
SO HOW DID YOU DO IT PLEASE? I CANNOT REPLICATE...
OpenOffice 4.1.5 on Windows 10 Pro. Folk like you helping folk like me, makes the world an easier place to be.
Re: Filling down, from another sheet's across cells
Please don't SHOUT, it is considered impolite.
Press F1 to open Help; search Transpose and see the process described.
Press F1 to open Help; search Transpose and see the process described.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
-
- Posts: 25
- Joined: Mon Nov 05, 2012 4:52 am
Re: Filling down, from another sheet's across cells
Sorry, capslock was on. I got it! Thank you, I misread the shift control enter part in help.
Thankyou, thankyou, thankyou!
Thankyou, thankyou, thankyou!
OpenOffice 4.1.5 on Windows 10 Pro. Folk like you helping folk like me, makes the world an easier place to be.