I have a need to use excel to track large quantities of welds on construction
sites. These welds are identified by component and are numerically tracked
by row and sequence (i.e., 1A, 1B, 1C, 1D....1J; 2A, 2B, 2C, 2D....2J; etc).
There could most likely be 180-225 rows like this in a single component. So
far, I have been unable to use Excel's auto-fill capability to prevent from
having to enter each column individually. Any suggestions?