Hello all,
I have a sheet with 700+ file names; starting at A3. In column C through J I want about 10 rows (and 7 columns) worth of information from each of the file names in column A. I realize I might have to manually go through Column A and add 10 rows in between each file name to give the proper space, but thats a separate issue (though if you have a quick idea of how to do this, that'd be great). In the past I've gotten help here on pulling information from different files. That being said, here's what I've got that doesn't yet work:
I can get this to work if I point to a single cell, say A11, just not the whole range, A11:G20
Thank you ahead of time for the help
Bookmarks