I'll try that in the morning. There are over 5,000 lines in one sheet and 20,000 on another. Hope the copy and paste special can be duplicated like a formula. I'll let you know how it works. Login to read more.