Forum Discussion
Combining Dynamic Table with Manual inputs
Hi all Happy New Year. Hope you can advise. I have a dynamic table within excel using the FILTER() function. Lets say this is columns A-E. What I would like to do is have a manual field n...
I'd enter the comments in another range, against the IDs.
You can then use XLOOKUP to display the comments to the right of the dynamic range.
See the attached version.
Thanks HansVogelaar
This could work but I also have a "tick" column so the user can mark rows completed.
The relevant rows then are striked through.
Your method is possible for this but also not as simple than just "ticking" off.
Is there any other method save adding another table?
See latest example
I think you do need a separate range. The attached version contains a different suggestion.