Hi - I'm new to VBA and having difficulty with the attached VBA.
I have a master sheet named "ScopeReq. Matrix". Each task on the master sheet has a department name (located in C:C) which handles the task. Each department can handle a numer of tasks.
I created a separate sheet for each department. Now I would like to have a code that looks at the master sheet matches the department in Column C to the name of the worksheet, copy the tasks and paste link. The past link allows each department team to update their indivdual sheet, sort it any way they like and still maintain the data on the master sheet.
Here is what I have so far, but it's not working. Is this even possible?
Thanks for your help.
-------------------------------
If (Worksheets.Name = "C:C") Then
Sheets("ScopeReq. Matrix").Select
Copy Range.Select = Column("C:C")
Selection.Copy
Sheets("ASD").Select
Range("A1").Select
ActiveSheet.PasteLink
End Sub
I have a master sheet named "ScopeReq. Matrix". Each task on the master sheet has a department name (located in C:C) which handles the task. Each department can handle a numer of tasks.
I created a separate sheet for each department. Now I would like to have a code that looks at the master sheet matches the department in Column C to the name of the worksheet, copy the tasks and paste link. The past link allows each department team to update their indivdual sheet, sort it any way they like and still maintain the data on the master sheet.
Here is what I have so far, but it's not working. Is this even possible?
Thanks for your help.
-------------------------------
If (Worksheets.Name = "C:C") Then
Sheets("ScopeReq. Matrix").Select
Copy Range.Select = Column("C:C")
Selection.Copy
Sheets("ASD").Select
Range("A1").Select
ActiveSheet.PasteLink
End Sub