Auto Populate Column onto other Sheet

[BrettOlbrys1]

I know this is probably easy, but my mind is blank. I have two sheets. Sheet 1 (column A) contains the data and this column can grow hundreds of lines per day.

I want all of Sheet 1 (column A) data, as it grows, to auto-populate Sheet 2 (column A). Sheet 2 will have multiple other columns, and will be setup as a Table.

What formula can I use that will auto-populate Sheet 2 (column A) with Sheet 1 (column A) data no matter how many rows of data are in sheet 1?

Thanks

Brett

 

[Fluff]

By using a normal range & a formula that will spill, such as Filter.