Hi Everyone,
I have a workbook with Sheet 1 in it. Each day Sheet 1 is updated with up to 600 rows of data. We have several rows that we need to copy data to for example, where Cells A3, A4, B3 & B4 below are empty I would like to copy A2 & B2 and so forth down column A & B. I'm trying to come up with a macro to do that if someone could be so kind.
Thank you!!
Column A Column B C D E F
<tbody>
</tbody>
I have a workbook with Sheet 1 in it. Each day Sheet 1 is updated with up to 600 rows of data. We have several rows that we need to copy data to for example, where Cells A3, A4, B3 & B4 below are empty I would like to copy A2 & B2 and so forth down column A & B. I'm trying to come up with a macro to do that if someone could be so kind.
Thank you!!
Column A Column B C D E F
Row1-00000000010054/000 | 20 OZ FOUNTIAN | $1.19 | 4 | 5 | $5.95 |
Row2-00000000010078/000 | 32 OZ FOUNTIAN | $1.39 | 21 | 21 | $29.19 |
Row3- | $1.19 | 1 | 1 | $1.19 | |
Row4- | 22 | $30.38 | |||
Row5-00000000010511/000 | Refill Fntn | $0.79 | 11 | 11 | $8.69 |
Row6-00000000010528/000 | 44 OZ FOUNTIAN | $1.29 | 3 | 3 | $3.87 |
Row7- | $1.49 | 17 | 21 | $31.29 | |
Row8- | 24 | $35.16 | |||
00000000011037/000 | 16oz Coffee | $1.39 | 4 | 4 | $5.56 |
<tbody>
</tbody>
Last edited: