C
Connie Martin
I'm working with a huge spreadsheet of over 20,000 rows. I need a macro that
will copy the number in a cell down to the first cell with another number.
In other words, cell A35 has, for example, 4500245842 in it. A42 has
450245989 in it. Then A85 has 450246910 in it. The macro needs to complete
A36-A41 with 4500245842, A43-A84 with 450245989, and so on down the 20,000+
rows. Is this possible? Connie
will copy the number in a cell down to the first cell with another number.
In other words, cell A35 has, for example, 4500245842 in it. A42 has
450245989 in it. Then A85 has 450246910 in it. The macro needs to complete
A36-A41 with 4500245842, A43-A84 with 450245989, and so on down the 20,000+
rows. Is this possible? Connie