Forum Discussion
I am not sure how to make this formula. on this spread sheet!
I have tried the pivot and am not sure I am doing it right, the input form sheet is constantly growing as we add more, my goal is to use the input sheet as a form that sends the information or data to the other sheets home, shop, auto. that will also constantly grow?
teb372020 Have a look at the attached file, where I implemented Detlef_Lewin 's recommendation. It demonstrates the power of Pivot Tables in cases such as yours. No need for separate facility sheets. The input form is dynamic. Just start typing a new entry at the bottom and it will automatically extend. The example pivot tables (PT1, PT2 and PT3) are all based on that Table and when it extends, the data source for the PT's changes with it. All that is left is refresh all pt's after you have added new entries on the input form.