Hello

I need help in updating values in the rest of my workbook from the import tab.

In the workbook there are 12 sheets as listed below

Import, Summary, Monday, Tuesday, Wednesday, Thursday, Friday, Monday., Tuesday., Wednesday., Thursday., Friday.

On the import tab I have the below columns

Fee Earner, Matter Number, Client Surname, Matter Type, Received, Checked, Notes, Can Go, Sent Check Name, Sent for Authoristation

Where Can Go or Sent for Authorisation is not blank I need theses values to be updated on the relevant sheet, the Matter Number is the unique value. The values should be updated in columns J and K. The Matter Number is in column C on all sheets except the import tab. Only two of the sheets will be updated at any one time e.g. Monday and Monday. The sheet names will be passed from my current code as a variable.

I hope you are able to help me on how I can do this.

Kind Regards
Mike