@specialk- It's a alot of rows so copy/paste is not an option nor is dragging all the way down. I've done this previously so not sure why it doesn't work now.

@Jetemc- no.