Forum Discussion
Making information auto-populate across sheets
Hello, I am looking to get information to auto-populate across multiple sheets based on budget codes being used for purchases. For example: Sheet 1 is a master-list of all purchases made and ...
=FILTER(A2:D7,C2:C7="Supplies-5432")
If you have access to the FILTER function you can apply this formula. This works across sheets as well. For visualisation i've made an example within one sheet. If you don't have the FILTER function a combination of INDEX and SMALL can be applied.