A
archsmooth
I imported from a database program, but now have a mix of language and data
on my spreadsheet,a small sample follows:
Task No. AF-1880M
Description MONTHY INSPECTION OF HINGE FOR EXCESSIVE WEAR
Maint/Toolroom MAINTENANCE Date Last Performed 07-10-15
Fortunately, the items imported in same-sized chunks, so I can sort similar
data by going to a new worksheet and maintaining a constant interval. In
cell A1 I type 'Sheet1!D13', in cell A2 'Sheet1!D23', cell A3 'Sheet1!D33'. I
would like to select these 3 cells and drag down to continue the pattern, but
the next six cells come out as D16,D26,D36, D19,D29,D39. Help!
on my spreadsheet,a small sample follows:
Task No. AF-1880M
Description MONTHY INSPECTION OF HINGE FOR EXCESSIVE WEAR
Maint/Toolroom MAINTENANCE Date Last Performed 07-10-15
Fortunately, the items imported in same-sized chunks, so I can sort similar
data by going to a new worksheet and maintaining a constant interval. In
cell A1 I type 'Sheet1!D13', in cell A2 'Sheet1!D23', cell A3 'Sheet1!D33'. I
would like to select these 3 cells and drag down to continue the pattern, but
the next six cells come out as D16,D26,D36, D19,D29,D39. Help!