VBA Copy Specific Column From Another Workbook

VBA Step-By-Step Guide

In this video, I will show how you can easily copy a specific column from another workbook using Excel VBA.

[mariarib]

THANK YOU for debugging live :-) It's nice to see everyone makes mistakes!

[rushibhuva]

This video is very useful, I just widening is there any tip I can use in order fetch 5 columns out of 20 columns by matching header.?

And also I want to overwrite data when I copy.

[ritwiknautiyal]

Hello Thanks for the great video . i have to copy more than 1 specific columns so can you please modify the code accordingly.

[sharadpatel]

i have to create multiple sheet from master sheet data file, fatching specific data & paste in specific form in multiple sheet can it possible ???

[king_khan]

Hi can you help me in creating a vba eg: i need to copy some coloumns lets suppose there are columns in a file to AG and I nees to copy some selected columns into a different sheets like 10 columns from different places not side by sides, hope you got my question.

[chrisk.]

Thanks, very nice. But why dont you have to declare variable a?

[Gudha_Ismintis]

Hi new subscriber here

At work - I have a master spreadsheet with missing data fields (columns) that are divided by different and repeating staff member names (rows) - which are continuously being added.

I want the staff members to fill in their missing data fields - without accessing my master

My theory is to duplicate the columns into a separate workbook for each staff member with their name pre filtered and saved for them ready to complete - each row having a unique reference number per row to emphasize how unique the row data is.

Questions:

What is the best way to lonl the master workbook to the individual staff workbooks

Via VBA how can i get the master workbook data to be automatically populated from the staff members workbooks ibto the correct rows - by using the unique reference column as the (IF / condition) to correctly match

[CriticAL_EX]

what do i need to change to copy multiple columns ? in this line For a = 1 To dWB.Sheets("Audit").Cells(1,
If dWB.Sheets("Audit").Cells(1, a).Value = "Entry Date; Auditor" Then

[HyttensRanders]

Hello sir

Can you help Me with one projekt that looks similar to this.

[marlboro]

¿Wouldn't be better to use PowerQuery? 🤔

[kamiatoys]

hi dude...
can u help me make a simple vba.

please reply this comment if u interest.