I have managed to paste a spreadsheet to create a table in Base, but where to from here? I imagine pasting a new table in each month, just keeping the current and previous months (so two tables), so I can compare any changes. Also the ability to highlight or alert me if the amount changes by more than $5-$10 would be the best. Thanks for any help!
Edited to add:
I have excel but as my software is a few years old it may not do what I want it to. I will look into Calc. I downloaded Libre because I wanted to experiment for a solution with Base (as I don’t have access, but do have a fair amount of experience with it) I did want to just use a spreadsheet but seeing as I’ll be importing two columns of spreadsheet, one which is client names and changes slightly month to month, and the second column which is commission received from each client, and I need to make sure the numbers stay with the respective client. IE: Mr Bloggs $16.72 Mr James $33.19 Fox & Fox $20.21
And the next month it could be: Mr Bloggs 20.89 Mr James $30.33 Mrs New $5.91
I want to be able to clearly see if the amount relating to each client is significantly different from the past month (indicating a possible issue or error). I was worried about trying to make a formula that wouldn’t be able to take into account if a new person was in the column, and mess up the numbers etc. Any thoughts would be welcome, and thank you for your initial answer.