Copy a row to multiple worksheets

[dadrew]

Hi, I need to copy a row from a worksheet and paste it into the next available row on another worksheet (or possibly more) in the same workbook.

I have added a sample Spreadsheet and you will see from it that row 2 has a 'Y' under Columns Set 1 and Set 3 so need to add them to the relevent worksheet on the next available row on the relevent worksheet(s). Whilst row 17 has a 'Y'under columns Set 4 and Set 6. There is a button that will add the row to a single spreadsheet but not when the 'Y' is found in multiple columns.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[dadrew]

Many thanks for all your help, works a treat.

[TMS]

You're welcome.