I would like to first state that I am very new to VBA, but am trying to learn it slowly but surely. I have attached two documents, ‘LU Vis’ and ‘Vis Standards’. The ‘LU Vis’ is a file that gets updated daily from an access database that I have no control over. The file I have attached is all made up but shows exactly what would be shown in the real file. What are missing from it are all the filters that the original one has on it that allows me to change the year, quarter, month, week, and day that I am looking at, but everything from row 8 and above is exactly what is shown. However, dependant on what I choose as my filters the names and numbers shown in row 9 and below change.
What I have shown in the file ‘Vis Standards’ is exactly what I am trying to create a macro for. In the ‘Vis Standard’ file, what I essentially need the macro to do is read the file ‘LU Vis’, specifically everything in column A, B, and C and from row 9 to whenever there is no longer any values listed. At times, there is the word “unknown” listed under a name instead of a number, which can be ignored. The numbers listed in the table FR and Standard are constant, except that in my actual file, there are 120 FR’s and standards. I need the macro to sort through ‘LU Vis’ then enter the Pcs and Hrs into the table in ‘Vis Standards’. Pcs corresponds to column B and Hours corresponds to column C, both respectively in ‘LU Vis’. I need each person to be put into their own tab within ‘Vis Standards’ in alphabetical order. If anyone could help with creating a macro that can do this that would be greatly appreciated. If possible, I would also love an explanation of what specific parts of the code does, being that I am trying to learn VBA at the same time. Thanks.
Bookmarks