I have a set of budget files (all the same format) that need to be updated. I have one file where I am putting the macro, and this can remain open while I cycle through the workbooks in a folder. I would like it to open the files, go to the source data file, copy a range, and paste it in a range on the target files. I figured this would be simple, but I haven't been able to figure this out. The code I have written (stolen from other coders online) feels like it should work, but it gets hung up on the [wsP.Range("T2").Select] statement. Clearly, it cannot find that worksheet, and I am having difficulty writing code that goes back and forth between workbooks when one of the workbooks is variable, and the name changes often. I started writing macros about 2 weeks ago, so any help is appreciated.
This is my first post, and I am not 100% sure on how to post the code.....hopefully this is right, and if it isn't, I apologize.
Bookmarks