Комментарии:
THANK YOU for debugging live :-) It's nice to see everyone makes mistakes!
ОтветитьHello sir
Can you help Me with one projekt that looks similar to this.
hi dude...
can u help me make a simple vba.
please reply this comment if u interest.
¿Wouldn't be better to use PowerQuery? 🤔
ОтветитьThank you, help me so much
Ответить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
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 Thanks for the great video . i have to copy more than 1 specific columns so can you please modify the code accordingly.
ОтветитьThank you so much Sir
ОтветитьThank you sir!
Ответить