Hello Everyone,

Just looking for a fairly simple macro (at least I think!)

I have column I and solumns J,K,L, and M. Here is what my data looks
like.

column I Column J Column K Column L Column M
Advisors Inc 1 2 33
55
33 55
8 11
11 15
25 55

ABN 33 88 574 44
339 828 57454
344

I have a spreadsheet like this with about 2000 lines. Is there a way
to autofill in the data so that it copies whats in the first cell of
column I, until the next blank row and does that all the way down the
2000 columns? I need to sort a few things and it will make life
easier!

The sample got a little fouled up, but it looks like you could use the
techniques at Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

And you may want to "hide" those duplicated values:
http://contextures.com/xlCondFormat03.html#Duplicate

"(E-Mail Removed)" wrote:
>
> Hello Everyone,
>
> Just looking for a fairly simple macro (at least I think!)
>
> I have column I and solumns J,K,L, and M. Here is what my data looks
> like.
>
> column I Column J Column K Column L Column M
> Advisors Inc 1 2 33
> 55
> 33 55
> 8 11
> 11 15
> 25 55
>
> ABN 33 88 574 44
> 339 828 57454
> 344
>
> I have a spreadsheet like this with about 2000 lines. Is there a way
> to autofill in the data so that it copies whats in the first cell of
> column I, until the next blank row and does that all the way down the
> 2000 columns? I need to sort a few things and it will make life
> easier!

--

Dave Peterson