Fill question
Is there a simple way to copy the account number in column A into each blank cell below – stopping where the next account number is listed. I need the data in cell A2 to fill cells A3 and A4, then the data in cell A8 to fill cells A9 and A10. The number of rows to fill isn’t consistently 2. It could be 1; it could be more than 3. It seems that this should be easy but I’m flumoxed.
Is there a simple way to copy the account number in column A into each blank cell below – stopping where the next account number is listed. I need the data in cell A2 to fill cells A3 and A4, then the data in cell A8 to fill cells A9 and A10. The number of rows to fill isn’t consistently 2. It could be 1; it could be more than 3. It seems that this should be easy but I’m flumoxed. Read More