Forum Discussion
Need help with formula
Hello, I need a formula that can fill in a table with data from multiple sheets but with specific criteria. So for example, I have a sheet that is one specific class that has student names correspond...
With permission of everyone involved, if I may add this tedious workaround.
How can I merge two or more tables?
When all tables have merged into one overall table, you could filter alphabetically.
Could also work with VBA, but as you have already been advised, Power query would be the most appropriate and elegant solution.