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.
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
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
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
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.
THANK YOU for debugging live :-) It's nice to see everyone makes mistakes!
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.
Thank you so much Sir
Thank you, help me so much
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 😊😊😊
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 th-cam.com/video/hz3f0vV1Khw/w-d-xo.html
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
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
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
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
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
¿Wouldn't be better to use PowerQuery? 🤔