Forum Discussion
contractormec
May 07, 2025Copper Contributor
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...
- May 07, 2025
I assume you need FILTER() function. Try the following formula-
=FILTER('TAB-1'!A3:G5000,'TAB-1'!A3:A5000<>"","No data found")
Harun24HR
May 07, 2025Bronze Contributor
I assume you need FILTER() function. Try the following formula-
=FILTER('TAB-1'!A3:G5000,'TAB-1'!A3:A5000<>"","No data found")