Relative Copy Range setting
 

Each period I download a block of data and index it for reporting. The Index
Vlookups reside A1 - AY1 My data block sits in AB5 - AZ100. Last period
I indexed the data by copying the Index down from A5 - A50; for current
period I need to copy the Index Vlookup formula range from A51 - A 100. Next
period, the raw data range will expand by an unpredicatable number of rows. I
need the VBA coding to indicate a relative paste range beginning at the first
empty row in Col A, ending with the last row number in the data block
beginning in AZ. Any help on how to configure that statement(s)? Thanks!