VBA Dynamic Autofill

[Littlemalky]

Ok so I have part numbers in the left-most column and each month listed on top with just 3 letters of the month. I need to do a vlookup to another workbook to input the past months data. The rows I put the vlookup in are static and they are rows 5 thru 27; however, the corresponding column is different based on the month. How do I input this formula in these cells? Is there a way to reference the rows without the column?

 

[jeffreybrown]

Sounds like you could use an Index/Match function.

http://www.contextures.com/xlfunctions03.html

 

[Littlemalky]

No. A vlookup does the job just fine. The other file that I'm pulling the data from is not set up the same as this with the months laid out at the top. The other file just displays one month's data and is not formatted in a way that I could use a index/match. This is more dynamic.

 

[jeffreybrown]

Care to post a screen shot?