Relative Copy Range setting

J

Jame

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Range, selecting/copying 1
Problems Pulling Data from 2 Rows into a Report 0
Another 'Copy To The Next Available Row' Question 2
Copy Filtered Data 4
Inserting and copying Rows based on a variable 2
copy/paste in the next column 4
Name a range with relative reference 2
paste range from one sheet to each sheet after 3

Top