So we’ve got round to adding our 4th sheet to our DIY growing spreadsheet.
Spreadsheet Spending works for us for the now and as before. Shared the formula we used. Just Because…
A quick look see at our eight column headings.
Select number 1 on the rows, to highlight the first row. Click on Data in the ribbon and from the drop down data menu select and click on, AutoFilter.
We want to import our random latin family names used in Column A of our Index Sheet.
Select cell A2 on our new Spreadsheet Spending sheet. Choose Data and then click on Validity from the drop down menu available.
In Criteria, change the All values, currently chosen and select Cell range.
Allow: Cell Range Source: SeedFamily (Taken from Our Named Ranges)
Enter named range, SeedFamily into Source (from index sheet, column A).
Provided you’ve clicked OK? A drop down box with our named range appears in cell A2.
Forgot named ranges? Click on Sheet and then Named Ranges, Manage.
Import the seeds / content from our index sheet named ranges into our Seeds Name, Column B, Cell B2.
Allow: Cell Range Source: INDIRECT(A2)
We are now able to choose content/seeds from each of our named ranges.
Random formula used for our totals of column E, Costs.
Spending Total: Column E, Cell E12 (Cell format currency)
Filter Sub Total: Column E, Cell E13 (Cell format currency)
Filter % of Total: Column E, Cell E14 (Cell format percent)
Random details added just to test is all.
Filtered to Asteraceae, just to test our formula works? Job done, Move On.
Memo To Self : Random Links
- Fork It and Move On (January 2019)
- Future Unknowns Growing Forward(July 2017)
- Self Sufficiency in Salford (February 2016)
- The Old Pint Pot Salford (September 2015)
- Tweaking The Tracks of the Home Grown Journal pdf (October 2013)