I am using the following VBA code to scan my table, locate where room number is > 1, count how many rooms, duplicate the rows. What I also need is when the rows are duplicated, I need a 1 placed in the field Room # for the first room , a 2 placed on the second room, etc. PLease look at the code...