VBA to Copy specific columns from one sheet to another - Advance VBA Tutorial by Exceldestination

This tutorial explains about VBA programming to copy specific columns from one sheet to another. Macro to copy only specific columns can be developed by using simple VBA Code and assigning this VBA code to Command Button.

[youy]

VBA program karne ke baad bhi .. aur sorting karni padhti hai.. thode logic complicated hai... but we successfully did it...All past study of programming become usefull

[davesmith]

Thanks for your information. This solution is really just a loop that copies row by row. It does achieve copying data from one column to another column it Works fine for small datasets but not great for 20, 000+ records. Recommend your other tutorial of copy by selected region for larger datasets.

[KayJohnsonArt]

Thank you. This video has been extremely helpful

[boisvlearn]

You really saved me a lot of time, man. Thanks

[salauddinkhokon]

Sir I watched your entire video I think this will very helpful for many people. I have also a this kind of problem with some sort of different, I have also a purchase record sheet, and I a also want to transfer that record to my daily purchase record table in my dashboard sheets based on date. so how do I write code for this. If you want to see my table design I want to show you, thank you.

[vtellada]

Exactly what I was looking for! Thanks man!

[SabirKhan-mkzq]

Hi thanks for making it simple to understand. Though is there a way to copy the column is slightly different format into other sheet?

[anhjaden]

Thanks. Can you make it to copy and paste from 2 different worksheets.

[rayarb]

I tried your code and it works very well. I am trying to copy multiple columns but I want to select the columns by their header names eg: Customer ID, Customer Name etc. I want Excel to find the header name (in case the column position changes later on (eg: Customer ID is now 5th column and not 1st) and then copy the contents under that header. Can this be done? I also want to copy to another new workbook instead of a worksheet on the same workbook. Thanks

[danendrapradipto]

Thank you for your Information. But how if you want to copy+paste to another file excel (not in 1 file excel)??? Thank you

[MegaTony]

Hello nice tutorial. What about if we want to continue posting new data under the previous one on the sheet 2? Thanks.

[shabarilucky]

thank you for making it simple, how to select in-between cloumns ( B, C, F, G, Q) in sheet 2 coloums ( A, B, C, D) . i have added manually by adding each work sheet coloums as explaind in toutorial . but it is taking 5-10mins . based on below reply form i have sent my work sheet to your gmail id . could you please help me out.

[markthomas]

Great video, easy to follow. thankyou

[lianhlc]

Hi, thanks for sharing. It seems does not work for longer range of columns for sheet one and sheet two. I have 16 columns from sheet one to select and paste to sheet two that have about 27 columns. How to workaround your above VBA for longer range of columns of data? Appreciate for your advice.

[pilarschumaker]

Thank you!!!! This really helped, the only thing is when I tried to copy Column A, B and C (ONLY) from Sheet "One" to Sheet "two" pasting to Column B, C and D it does not work, however if I set it to paste it on Column A, B and C it works just fine. With this formula, It seems like the pasting has to begin on Column A which is the first column. However I would like it to paste starting on Second Column (Column B) as I do not want the numbers to be changed on Sheet "two" Column A.

[richardnina]

Thank you very much!
Could you please give the code for doing the same but automatically from a specific cell on another sheet (i.e.: Print)?
NB: That latter sheet has information such as Name and signature, and date of order.

[tereslok]

It is a great info contained in the tutorial. I have it tun in my excel. There are around 900 rows needed to be copied, the VBA code made the screen flicking during the copy process. Have anyone encountered this problem?

[hulidlo]

Very helpfull video. I have but one question. If I want to repeat that macro, but not to delete all the data I have already copied in the past. But Also I do not want to data which were already copied in the past to be copied second time.. How to obtain that ?

[deeprajdhar]

Hi, thankyou soo much for this informative video, can you please help me with the VBA code to copy Specific Cells from Multiple Workbooks(from a single sheet) from each workbook and paste it in master sheet?

[dipankarroy]

sir,

I watched your video, it was great. "Transfer data one sheet to another sheet specific column".
I did the same way as you have shown VBA Coding, but there is a problem.When I am transfer data,
the old data is being saved. I want the new update data to be transfer (save) only.
Verify any unique code(Specific column) before transfer and then save.
It is very good if you do any such video.

Thank you