I am currently working on an integrated set of workbooks, where I need to transfer data values between workbooks. In order to do so I need a VBA Macro that can copy non-adjacent cells (ex. the locations of the cells are J4, J8, J12, J16....etc) and insert it in the other workbook with a different structure (ex. the space between the cells would be 4 instead of 3.)
This is my first time using VBA so I'm not sure if it's possible. I'm using Microsoft 365.
This is my first time using VBA so I'm not sure if it's possible. I'm using Microsoft 365.