VBA Copy Specific Column From Another Workbook
HTML-код
- Опубликовано: 3 сен 2022
- 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.
Download the code here: codingmodule.com/index.php/20...
Excel VBA Projects: codingmodule.com/index.php/ca...
THANK YOU for debugging live :-) It's nice to see everyone makes mistakes!
Thank you, help me so much
Thank you so much Sir
i have to create multiple sheet from master sheet data file ,fatching specific data & paste in specific form in multiple sheet can it possible ???
what do i need to change to copy multiple columns ? in this line For a = 1 To dWB.Sheets("Audit").Cells(1, Columns.Count).End(xlToLeft).Column
If dWB.Sheets("Audit").Cells(1, a).Value = "Entry Date; Auditor" Then
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
Hello Thanks for the great video . i have to copy more than 1 specific columns so can you please modify the code accordingly.
you can check this video ruclips.net/video/hz3f0vV1Khw/видео.html
Thank you sir!
sure let me know if there is anything else I can help you with
Hi sir last question. What if the scenario would be like this:
For data 1 workbook- you will copy the region, rep and item but will be pasted on columns A, B, and C of the Mytool workbook
Then,
For date two workbook- copy order, date and unit but this will be pasted to columns D, E and F of the mytoool workbook.
And so goes with data 3- random data copied and will then be pasted to different columns of the mytool workbook.
I hope you can help me with this. Thank you
@@arthurcv15 is the data from workbook one realated to workbook two?
Yes, Sir. Currently i have 27 workbooks that needs to be copied and pasted to a central file( but i only need a specific data to be copied per workbook) . I can't do power query due to large memory
@@arthurcv15 okay let me try that later 😊😊😊
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.
please send me sample source files and a sample output file -> happycodingandlife@gmail.com
Thanks, very nice. But why dont you have to declare variable a?
I forgot :), I should declare it, good practice to always declare a variable before using it and include an Option Explicit at the top of the module
Hello sir
Can you help Me with one projekt that looks similar to this.
How can I help? Please send an email to happycodingandlife@gmail.com
hi dude...
can u help me make a simple vba.
please reply this comment if u interest.
Sure how can I help
¿Wouldn't be better to use PowerQuery? 🤔