How to Design a Macro to Copy/Paste Specific Columns to Another Sheet in Specific Columns

I am trying to design a Macro to Copy/Paste value and formatting from one sheet that is linked to other workbooks already into another worksheet that can then include other formulas, formatting and have a sort list to change the order of the data ect.

- Select Specific Columns (max 500 rows of data needed) from the Summary Sheet
- Copy to the Well Stats tab into specific columns that will be in a different order than in the Summary Sheet and will need some columns in between that won't be copied but will instead perform their own calculations


This is the code that I have started but I'm afraid that it will run very slowly once I actually setup 20-30 columns to copy/paste over. Is there a simpler code? I have attached my excel sheet. Thanks in advance!

Code:

Please Login or Register  to view this content.

Once you stop flipping back and forth unnecessary between sheets, this should be efficient enough, even after you expand to 20+ columns.

Please Login or Register  to view this content.

By setting your worksheet names into variables at the top of the code, then using the variable names in the COPY and PASTE commands, you can change your sheet names anytime you want and only have to edit the SET commands at the top, then that change flows down through the code automatically.

Welcome to the forum ankitsondhi may I suggest you to create a new thread for your query.
Thanks

The macro absolutely pastes exactly as you've described in your original post. Perhaps instead of talking in VBA code, you should simply mockup another WELL sheet that shows what you want the results to be passed on the sample SUMMARY sheet.

Please Login or Register  to view this content.

Just some range typos, sorry. Be sure to get the columns noted correctly as you add more, better than I did the first time.

Please Login or Register  to view this content.

Just some range typos, sorry. Be sure to get the columns noted correctly as you add more, better than I did the first time.