Autofill macro help!!
 

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!

Autofill macro help!!
 

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

" 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