I'm trying to build something that pulls data directly from another sheet by filtered criteria. If the criteria matches, then data is pulled into another display sheet. However, my challenge is that whenever the data is pulled, it overlaps with each other.
Is there a way or code that can make it smarter? Say if under the 'Math' there are lots of data, then the row starting 'geography' automatically goes down to avoid overlapping. Can anyone give me some directions as to what function to search for things like this?
I've also posted the same question on another forum seeking a smarter way of coding, link is attached below.
Thanks heaps guys!