Forum Discussion
Solved
Forms / Excel - Functions
Hello all, I have Microsoft Forms being used to send in Quality concerns which populates to an Excel sheet. I would like to have multiple sheets for the many different departments and also have a ma...
The attached workbook shows one (less than satisfying) solution.
I am interested to see how the community gurus handle this.
The attached workbook shows one (less than satisfying) solution.
I am interested to see how the community gurus handle this.
Using Lambda with OFFSET and BYROW works wonderfully. Used the fill handle and dragged to my desired row and now every new entry it automatically updates. Thanks so much for the help.