Hi,

This post refers to the question in the following thread:

http://www.excelforum.com/excel-prog...copy-data.html

I have tried to use both of these methods for my data. The second method did not work for me, and I have just realized that the first method doesn't even work for the original dataset. If you compare the 2 methods using the original dataset, you'll see that a large number of the barcodes don't show up with the first method, whereas they do with the second method. This suggests to me that there is something wrong with the formula being used, which is unfortunate for me because the other formula doesn't seem to work for me. If someone could fix the 1st formula I would like to try to use it, otherwise I will post my data and perhaps someone can adapt the second formula to it.

thank you