Thanks for the reply.
Have uploaded an example of the spreadsheet. Link is
Box
In the workbook there are 12 sheets which are updated manually, from which the 'data' sheet will update.
In the 'Data' sheet there are columns which contain IF statements with criteria based on the values in other sheets or columns.
Sheet 1 and Sheet 4 have a column that will update with a TRUE value if the formula conditions are met (Sheet 1 = column V and Sheet 4 =
column P.
Using any TRUE values in those columns, there is formulas in the 'Data' sheet in column O & P which will also return a TRUE value.
Based on the values in O & P, the K column will then return YES or NO. Column N is a manual entry and is there incase a NO to YES change needs
to be made that doesn't come from the Sheet 1 or Sheet 4.
In terms of using the workbook - The white columns are for manually entering values, the pale grey will populate based on formulas and will be seen
by the user, but the dark grey columns will be hidden from view of the user.
I have added the VBA code which has copied over the initial records which had 'YES' in column K. However it doesn't pick up any changes after that.
For example, I ran the VBA code which added the two records with "YES" in column K. I then made a manual change to "Jane Jones" record in the 'Sheet 4' which then returned the TRUE value in column P in the 'Data' sheet, which returned YES in column K.
However, the NO to Yes change didn't then copy the data to the 'EQUAL' sheet.
The trigger change needs to be when the 'Data' column column K changes from NO to YES, but the change won't be manual it will be the result of a formula if the conditions are met.
Can you advise?
The VBA code is in the Data sheet.
If we can solve this issue, I would like to apply a VBA to each sheet, if columns Z:AJ return a TRUE value, it would copy the names from H:I into columns H:I within the specified sheet.
For example;
if 'data' column Z is TRUE, copy H:I to 'Sheet 6' sheet; column H:I
and so on for the other sheets.
TIA