Filtered data (sourced from one sheet) on different sheets.

Discuss the spreadsheet application
Post Reply
avaizhashmi
Posts: 11
Joined: Sun Nov 25, 2018 2:32 am

Filtered data (sourced from one sheet) on different sheets.

Post by avaizhashmi »

I am developing a sheet system for my accounts.

I have raw CSV data on one sheet. I will keep pasting more data here as time goes on.
I am recalling? the data on other sheets using =$Accounts_RAW_DATA.A3

I am aiming for a rather dynamic filtering system so that if I am on my Chequing Account for ABC bank, only those transaction with "Chequing ABC Bank" value would show up and not the others. And the math would follow from there.

I think filtering system is not changing the sum of transactions automatically as the rows are just hidden.

Please give me a few pointers.
OpenOffice 4.1.3 on macOS Sierra 10.12.6 (16G1510)
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Filtered data (sourced from one sheet) on different shee

Post by RusselB »

Please upload a sample of your CSV or your spreadsheet so that we can look at the layout. Some dummy data would also be helpful.
Without that information, I'd be taking wild shots in the dark as to how you could do this, as some of the methods I'm thinking of require certain information to be located in certain locations.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
avaizhashmi
Posts: 11
Joined: Sun Nov 25, 2018 2:32 am

Re: Filtered data (sourced from one sheet) on different shee

Post by avaizhashmi »

Here and thanx :)
Attachments
DataOnMultipleSheets.ods
(61.71 KiB) Downloaded 87 times
OpenOffice 4.1.3 on macOS Sierra 10.12.6 (16G1510)
Post Reply