I just wanted to Thank You in advance for reading and possibly helping me. I have some knowledge of VBA but I have issues figuring out the intricacies unless I am modifying an already existing code. I am learning.
I have been trying to get a macro that will open a different workbook, find the sheet, insert a blank range, copy data from row above and paste it is a value in the newly created range. This macro will need to repeat this in about 11 workbooks with multiple sheets in each. I have attempted to do this with macro recorder and creating a few objects but I am running out of luck when it attempts to switch to the next workbook and change sheets. Above that... I know there must be a better way as this seems to be very manual and the code will be super long when its done.
I have included a copy of a mock up for what I am attempting. It consists of 3 workbooks. The main workbook has the macro and the other two will be the ones modified. Again, it will need to do this with about 11 workbooks in the end. Changing the VBA script to the location you saved them should work and you can see what my problem is.
Any help at all would be very very appreciated. I am learning but I am still using macro recorder as my primary means which is probably the issue in itself.
Thank you for reading.