Hi there,
I'm trying to produce a spread sheet that can be downloaded multiple times that with the click of a commandbutton updates the sheet based on a master copy. The spread sheet is a project check list which is constantly getting updated with new lines. The master copy is on the central server.
I'm trying to construct a Macro that loops through two of the rows of data in the master copy - one contains the category (i.e. safety, financial, project management) and the other contains the specific task that must be completed and checks for new lines that are not in the project managers copy of the checklist. When it finds these lines it adds them to the project managers list.
Any help with this would be much apprieciated.
Cheers
I'm trying to produce a spread sheet that can be downloaded multiple times that with the click of a commandbutton updates the sheet based on a master copy. The spread sheet is a project check list which is constantly getting updated with new lines. The master copy is on the central server.
I'm trying to construct a Macro that loops through two of the rows of data in the master copy - one contains the category (i.e. safety, financial, project management) and the other contains the specific task that must be completed and checks for new lines that are not in the project managers copy of the checklist. When it finds these lines it adds them to the project managers list.
Any help with this would be much apprieciated.
Cheers