UPDATE! I literally just typed the data in the cell under the filtered column, and now see it becomes part of the filtered data! Lol. I did say 'simple'. Lol. Thanks!

Because the condition I put was minimum of 10 and maximum of 15. So it won't allow me to enter anything where the length is less than 10 or more than 15

@@trumpexcel misread it as 1 , thanks!

Any chance you are counting the header row of each table, as the final result only has one header row

@@trumpexcel no. i solved the issue with locale!@

Usse transpose hoga, flip nahn hoga

@@trumpexcel hn wo to row ko column main convert karega. Thanks

What version of Excel are you using. If using an older version, you will first have to install the free PQ add-in

I recorded this video with Excel 365. But I did notice that it works sometimes and sometimes it doesn't. Not sure what's the issue

@@trumpexcel I've never been able to get this to work on 365 which is unfortunate because other techniques are far more laborious and don't always give you the outcome you desire. Still, this is an excellent video showcasing what can be done with Find and Replace.

It should work even if the other file is closed

Thank you so much for the kind words... Glad you found the videos helpful 🙂