(Solved) – VBA to automatically copy row between sheets based on cell value


I am looking for a code that will automatically copy an entire row from sheet 1 to sheet 2 (next available row) once the value ‘Yes’ in column H is selected from a drop down list

The workbook will be in constant use for many years to come, and will need to keep previous historical entries (no overwriting)
Sheet 2 will eventually be used to populate a third sheet where the values are laid in a report format but I only need the the auto population of sheet 2 at this stage
I’m pretty new to VBA and all efforts to use similar codes have ended in failure

Leave a Reply

Your email address will not be published. Required fields are marked *