Hi All,
I have searched for the solution to my problem, but havent been able to find one that fits my needs. I apologise if i have missed a similar post, but its not for a lack of searching...
I have a worksheet (Referrals) with a particular column (T) that will contain either a date or either 'N/A or Pending'. What I am attempting to do is copy the data from cells C, D, N, P and T in each row if T has a valid date, or does not contain either N/A or Pending. This data should then be copied to another worksheet (Needs).
I am hoping that this can be made dynamic so that the worksheet that the data is being copied to will automatically update to reflect any changes to the initial worksheet and can thus be used to produce up to data statistical data.
Thankyou in advance for any help that is available.
I have searched for the solution to my problem, but havent been able to find one that fits my needs. I apologise if i have missed a similar post, but its not for a lack of searching...
I have a worksheet (Referrals) with a particular column (T) that will contain either a date or either 'N/A or Pending'. What I am attempting to do is copy the data from cells C, D, N, P and T in each row if T has a valid date, or does not contain either N/A or Pending. This data should then be copied to another worksheet (Needs).
I am hoping that this can be made dynamic so that the worksheet that the data is being copied to will automatically update to reflect any changes to the initial worksheet and can thus be used to produce up to data statistical data.
Thankyou in advance for any help that is available.