Looking for opinions on this, not sure if it is even doable. I have a spreadsheet called info.xlsx that data is entered into. It is all linked to a template. Is there anyway that the template could automatically be updated to show only the rows if there is data in a specific cell? For example, there are 1050 rows and the columns go from A: AL and I want to only show the row if there is data in column AK.
I can filter it to show anything with .01 or more, but the template doesn't automatically update when the information is added to the info spreadsheet.
Not sure if this is even a workable solution, maybe there are other suggestions?
Thanks as always in advance!
I can filter it to show anything with .01 or more, but the template doesn't automatically update when the information is added to the info spreadsheet.
Not sure if this is even a workable solution, maybe there are other suggestions?
Thanks as always in advance!