VBA filter & pull data from another sheet, but currently data overlaps after pulled

Hey guys,

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.

http://www.mrexcel.com/forum/e…sheet-based-criteria.html

Thanks heaps guys!

Re: VBA filter & pull data from another sheet, but currently data overlaps after pull

Hey guys, I've solved the problem using the

Range("c" & Rows.Count).End(xlUp).Offset(-1, -2).Select

coding