Forum Discussion
Solved
Make a list that auto-populates data
I'm working on a workbook with 2 tabs. The intent of this workbook is to create a order list based on what is entered. What I'm trying to achieve is the following: In TAB 1 all information has bee...
I assume you need FILTER() function. Try the following formula-
=FILTER('TAB-1'!A3:G5000,'TAB-1'!A3:A5000<>"","No data found")
Thank you! This worked perfectly!