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.
Using LAMBDA with OFFSET and BYROW makes it very close but every link is just a copy of the first URL and not individually linked with there corresponding entries.
I went straight to using LAMBDA with OFFSET and BYROW, this seems like it's working with what I'm trying to accomplish I appreciate the help.
