On 'Sheet1' I have multiple rows of data. I autofilter on Column 'A' and only display a single employee ID number. This results in only rows 15, 37, and 197 being displayed. On 'Sheet2' I want to enter a formula in cell 'A1' that pulls a specific range of the displayed (not hidden) rows in column 'A' from 'Sheet' 1. What is the formula for this?