Forum Discussion
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 main sheet to display metrics as new data is being entered.
The issue I ran into early on was I could not use any functions in said workbook due to it not being a macro enabled one. I compensated this by creating a new macro enabled workbook that has a =Filter pulling from the first workbook.
What I was hoping to accomplish was that each Supervisor can view the sheet and review the Quality concerns that pertain to them and the departments they oversee. With that if a photo is attached from Forms then the =Filter function will not be clickable.
Is there a work around in doing what I've mentioned ?
I hope I've explained it well enough to make sense and if there is anything else I may need to add please let me know. Thanks for everyone's time.
The attached workbook shows one (less than satisfying) solution.
I am interested to see how the community gurus handle this.
5 Replies
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.
It would be helpful if you show your desired output.
