Hello,
I have about 100 files in a single folder, all made from a single template. I would like to pull information from these files into a single master file. The problem is that I dont want all the data from each spreadsheet, only specific cells. For example, I would like to pull cells I9, F4, F5, and K3 from each file, and then paste them into a new file in cells B3,C3,D3,E3. Then take the same cells from the next file,and put them in cells B4,C4,D4,E4.
Any thoughts on how to do this?
Thanks in advance!