Ask Your Question
0

How to use data between sheets in libre calc?

asked 2017-07-17 14:10:12 +0200

leifr gravatar image

One sheet with data in four columns. Then I want to add sheets where data ar sorted after colums B (C and D)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2017-07-19 09:55:52 +0200

erAck gravatar image

If you want to sort the data and place the sorted result on a new sheet: add a new sheet and in Sort Options check Copy sort results to and enter Sheet2.A1 as destination (if the new sheet's name is Sheet2, else adapt) where the output will start. You can also name a cell (Ctrl+F3) on the new sheet before entering the Sort dialogue, named cells are available in the list box to choose from.

edit flag offensive delete link more
0

answered 2017-07-18 11:24:01 +0200

Kruno gravatar image

updated 2017-07-18 11:25:00 +0200

You can access data in another sheet by typing sheet name followed by dot. If you have 'Sheet1' with content in cell A1, and you want that same content on 'Sheet2' in cell B2 you should enter

=Sheet1.A1

into cell B2 in Sheet2.

Download Calc Guide from https://www.libreoffice.org/get-help/....

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-17 14:10:12 +0200

Seen: 40 times

Last updated: Jul 19