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.
Filtered data (sourced from one sheet) on different sheets.
-
- Posts: 11
- Joined: Sun Nov 25, 2018 2:32 am
Filtered data (sourced from one sheet) on different sheets.
OpenOffice 4.1.3 on macOS Sierra 10.12.6 (16G1510)
Re: Filtered data (sourced from one sheet) on different shee
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.
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.
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.
-
- Posts: 11
- Joined: Sun Nov 25, 2018 2:32 am
Re: Filtered data (sourced from one sheet) on different shee
Here and thanx
- Attachments
-
- DataOnMultipleSheets.ods
- (61.71 KiB) Downloaded 92 times
OpenOffice 4.1.3 on macOS Sierra 10.12.6 (16G1510)