Howdy Paul, in reply to your questions:

. cells in column B of Data are unique
. numbers and letters are random, there is no mathematical increase or anything like that
. Data sheet is manually populated. Then by mean of macros the rows are copied and pasted into Report . Attached please find the sheets as they look like in "real life" (I have left the macros in this workbook for you to see).

As you can see in Report the cells have been placed but now I need to see their positions in Data. Also, please note that once the cells are in position it might be necessary to move them to their final destination. This will happen, again, by using macros that will run directly from "Report" (in report select the cells you want to swap with ctrl and then push ctrl+s).

Hope this helps

Thank you very much

Attached Files

Sy7.xls (38.5 KB, 15 views)