All,

I have a spreadsheet with columns A-Y with various data. One a second tab, I want to copy an entire row (A-Y) to the next available empty row. The action needs to be triggered by Column Y when from a list, "100" is selected.

Thanks in advance for your help. This level of code is WAY over my head. I do traditional IF/Then statements, VLookup, math formulas so please provide any explanations with that in mind.

Patrick L