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
Bookmarks