Copying and pasting from template
I want to build some VBA that lets me Copy and Paste (As special values) from one template to another. The source template looks *extremely* similar to the destination template, but the destination template may add columns before the data I want to copy and paste without the source template doing the same. How would you approach this? I can see Power query or Identifier Columns being the best bet, but both source and destination already have a decent bit of chug on them, so trying to keep as light as possible.
TLDR; Want to Hard Paste (can’t have a link to an external book at the end) Columns B-K from source workbook sheet1 into D-M of recipient workbook sheet1 . Source B-K may become C-L and Recipient D-M may become E-N at any moment and want the code to not worry about that. Feels like It should be super simple but can't think of the most efficient way to do it
[link] [comments]
Want to read more?
Check out the full article on the original site