Hi Everyone,
I apologize if this question has already been answered. I have been trying to figure this out forever and I cannot get it to work. I have a macro in which I recorded a vlookup that I insert into column G that pulls from column F to give me an account name from another file.
I have about 30 different files that I use this macro on, and they all have a different number of rows. Is there a way to get the macro to autofill down to the last row of data in column F? For example the first file I run the macro on might have 188 rows, but the next file only has 30. Here is a copy of what I have so far:
Any help is greatly appreciated.Please Login or Register to view this content.
Bookmarks