I have a table of data that has at least 60 rows in it that tracks the newest installed gas cylinder on some test equipment. Each piece of equipment has its on row and as we change the bottles, we enter the new cylinder # and reference # to the end of the row. Because some of the equipment uses much more quickly than others, some of the equipment is on its first bottle of the year and some is on its third already. What I want to do is scan each row (starting at row 3, column "I") in columns "I" through "AA" and find the last two columns of data and copy it to columns "C" and "D" of the same row so that when we audit the bottles the latest bottle is listed at the beginning of the sheet to make tracking easier. The data is not always numbers, it is text as well.
I am not versed in VBA at all, but I figured it was the easiest way to accomplish this task. Can anyone help me with this? I want it to be open ended enough that if I add more rows the program will not have to be modified.
I am not versed in VBA at all, but I figured it was the easiest way to accomplish this task. Can anyone help me with this? I want it to be open ended enough that if I add more rows the program will not have to be modified.