Wow you lost me with that, I feel really stupid. Lol. What I was thinking was to add a column "k" that would not be printed and would simply be used for calculations. So that column would contain a number starting at #1 and then increasing by one for each line of text is entered or copied and pasted into the program. Actually if the numbers are not going to be seen or printed the. I could simply make each row a number. That would solve the problem.

The question then becomes how do I get the two pages to update each other. So for example lets say that row # 1 device has been tagged as failed, now that row is automatically copied to the failed devices page from another macro. Now that it is on that page a user uses the dropdown list to chose replaced. At that moment the device would be removed from the failed devices page and results column on the initiating devices page would be updated to show as replaced. I guess I would simply need to compare the rows from each page then to get this result?