Hi there, VBAnoob created this Macro for me, to have excel check column L in Sheet "Record Audit" and if there are any values below 80%, I would like excel to copy Column A and Column L from that row and paste the row(s) into column D and E of Audit Log Sheet.
This worked great BUT I need the ability to change the number of columns in Record Audit. I want to add File 11, File 12, File 13, which would cause the "scores' on column L to shift.
Can someone tell me what part of the macro code I need to modify to adjust for the additional columns added? I have tried a few things but just got errors.
Also, I want to be able to add more sheets, one for each month, and use the macro on each sheet, on a month to month basis. I then want the macro to paste the values below 80%, into the Audit Log, each time I run the macro on each monthly Record Audit Sheet. When I try to create the same macro, but with different sheet names, on a new sheet, sy February Record Audit, I get an "ambiguous name" error.
How can I "duplicate" and use this macro on 12 different Record Audit sheets that will each represent a month of the year?
Thanks
Bookmarks