Looper File That opens files from a list to paste values from a cell in a list

[amartin575]

Hello,

I have the following looper code. The looper looks at the list of files to open on the File List tab. It opens each file and copies specific data out stacking it onto one tab called Extract Data. This code works great. I then make a copy of the Extract Data tab and name it Quote Rate Data Updated. I do this to do some analysis and make changes to the numbers. What I am stuck on now is once I have the numbers updated and complete I need to create a new looper that opens the files listed on the File List tab and copies the numbers in columns C and D on the File List Tab of the attached file and pastes values them into cells K184 and L184, save and close. Then move down to the next file on the Files List tab until it has finished all of them. I am thinking I can use a lot of the same code I used to copy the data in. Any suggestions?

Please Login or Register  to view this content.

[amartin575]

I was hoping I could use something like this where i replace the code with code to copy from C:D on the File List Tab into the file that gets opened.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[amartin575]

I tried this and get an error that says Compile error: Method or data member not found for the wksFileList.ActiveCell.Offset(, 2).Resize(1, 2).Copy
part of the code. I think I am almost there! Thanks for everyone viewing.

Please Login or Register  to view this content.

[amartin575]

Can anyone help push me past the finish? The code I have so far is below and it is breaking. This is the only piece I believe to have left. It is breaking where I have the code telling it to go back to the Quote Rate Looper file and grab the two cells in column C & D of the current workbook opened from the file list tab.

Please Login or Register  to view this content.

[apo]

This should do it .. or at least give you something you can modify to achieve your goal..

Please Login or Register  to view this content.

[amartin575]

You da man! Thanks! I made some modifications to it. The final result is shown below.

Please Login or Register  to view this content.