Hi Don,
Sorry for any confusion I may have caused. I tried to give a simple example for ease of communication. I was thinking it didn't matter how many columns were in a spreadsheet since each row would be copied in its entirety. It sounds like that was a bad assumption on my part. The issue is I will get different number of columns from different customers. In addition, there will be different data in some cases. Prior to running your code I will do a manual "normalization" for each spreadsheet by moving the reference designators to column A and the quantity to column C. Thanks, Pat