March 29, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Copying and pasting from template

Our take

When dealing with dynamic templates in Excel, creating a VBA solution for copying and pasting values can streamline your workflow significantly. Given the similarity between your source and destination templates, a robust approach involves using identifier columns to ensure accurate data transfer, even as column positions change. By focusing on a hard paste of specific columns from the source workbook to the destination, you can maintain data integrity without the overhead of external links. This method allows for flexibility and efficiency, accommodating future changes seamlessly.

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

submitted by /u/Codenamerondo1
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Paste Without Format NOT ctrl+VI looked everywhere but couldn't find a satisfactory answer (which probably means it doesn't exist). I am managing a shared excel file with people who will copy and paste information in and will be able to grab that information and do things with it. The issue, is every time they paste something it breaks my conditional formatting which is the main way I am able to sort through and organize what they give me. Is there a way to have the default past as paste without formatting because I can not control how they paste the information in. (No asking them to do ctrl+Shift+v will not work, please don't even recommend it.) If there are any other ideas on how to deal with this issue, please let me know. EDIT: NO CTRL+SHIFT+V I am not the one pasting these values in, others are! Conclusion: There isn't (currently) a way to do this, but the general consensus is to have them paste all the information into its own thing and then use power query to get the data I need. Thank you all for the advice! submitted by /u/United-Twist-3839 [link] [comments]

Copying and pasting from template

Related Articles