I am trying to create VBA that copies over data from a summary tab onto separate tabs based on initials in the summary tab. I only need certain columns transferring over.
I have attached a mock spreadsheet for visualisation purposes.
So the all the information is manually added to the summary tab. I then need data from columns C,A,D, N (column N needs to be free text and have the ability to be changed) ,M and H to be transferred to the correct tab based on the initials in column J , and the data is then transferred to the correct tab into columns A-F . Once the work is completed the date complete will be added. Once the date is added I need the row to be deleted from the initial tab but kept on the main summary tab.