I need some VBA within an Excel Spreadsheet to generate an unspecified amount of tables.
It needs to create a new table using the template (Sheet "Non-Conformance") and pull through data from the sheets listed below when "Score" is less than 4.
Sheets to scan:
Ops Ctrl (Must)
Ops Ctrl (Resp)
Ops Ctrl (Stress)
The data being populated would be as follows:
Audit Criteria: Column B
NC Category: Column V
NC Ref: Auto-generated, format to be determined
Also there's a slight issue when scrolling the offset sometimes messes up - please can that be fixed too!