Excel 2007 : Return Column of Information without VLookup

[amiebf]

Hi there - first post so forgive me.

I have a workbook with two sheets - a master and a secondary. What I am looking for is a function or reference that will pull column A information from the master into the secondary, while the only reference point is the column header. The secondary sheet's column A is blank, with the exception of the aforementioned column header, and I'm looking to avoid copy and pasting the information from the master weekly.

Any ideas? TIA.

[Palmetto]

Any ideas?

One way:

1. Create a Dynamic Named Range for the source data in column-A
2. Use Advanced Filter (no criteria, copy to another location), using the named range as the source.
3. Automate the Advanced Filter with VBA

[amiebf]

thank you x infinity. worked beautifully.

[teylyn]

or with INDEX/MATCH

=INDEX(Sheet1!$A$1:$Z$100,ROW(),MATCH($A$1,Sheet1!$A$1:$Z1,0))

and copy down. adjust ranges to suit