Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 29th 08, 04:40 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 11
Default AutoPopulate Cells

I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.

Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck.

  #2   Report Post  
Old October 29th 08, 04:51 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1,805
Default AutoPopulate Cells

One way is to (assuming your list is in Col A)
type
=A1 in B1
Type
=IF(A2="",B1,A2) in B2 and copy down till the last row

Copy Col B and PASTE SPEICAL|VALUE over Col A
Delete Col B

"khuff" wrote:

I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.

Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck.

  #3   Report Post  
Old October 29th 08, 06:47 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default AutoPopulate Cells

Select the column and F5SpecialBlanksOK

Type an = sign in active blank cell then point or arrow to cell above.

CTRL + ENTER to fill the blank cells.

Copy/paste special.values/ok/esc


Gord Dibben MS Excel MVP

On Wed, 29 Oct 2008 08:40:06 -0700, khuff
wrote:

I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.

Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck.


  #4   Report Post  
Old October 30th 08, 06:29 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default AutoPopulate Cells

Hi,

You should reconsider Gord's suggestion, it is the method of choice for
solving these types of problems and it will work on multiple columns. You
should give Gord's solution a check Yes.

--
Cheers,
Shane Devenshire


"khuff" wrote:

I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.

Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck.

  #5   Report Post  
Old November 10th 08, 06:20 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 11
Default AutoPopulate Cells

Hey Gord,

I used the formula Sheeloo gave me and it worked great although I had to
pull the fill tool for awhile before I was finished.

As Shane says your suggestion seems to be the preferred method and I will be
trying it the next time I download and convert one of these documents I have
to work with. Thanks to all of you for the help and sorry for taking so long
to reply.



"Gord Dibben" wrote:

Select the column and F5SpecialBlanksOK

Type an = sign in active blank cell then point or arrow to cell above.

CTRL + ENTER to fill the blank cells.

Copy/paste special.values/ok/esc


Gord Dibben MS Excel MVP

On Wed, 29 Oct 2008 08:40:06 -0700, khuff
wrote:

I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.

Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck.





  #6   Report Post  
Old November 13th 08, 09:18 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 11
Default AutoPopulate Cells

Works like a champ! Wish I would have asked about this a long time ago.

Thanks Again

"ShaneDevenshire" wrote:

Hi,

You should reconsider Gord's suggestion, it is the method of choice for
solving these types of problems and it will work on multiple columns. You
should give Gord's solution a check Yes.

--
Cheers,
Shane Devenshire


"khuff" wrote:

I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.

Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autopopulate cmulvey Excel Discussion (Misc queries) 2 August 11th 08 10:57 PM
Autopopulate from a different sheet? aswag74 Excel Discussion (Misc queries) 3 September 13th 06 06:06 PM
Autopopulate with zero roy.okinawa Excel Worksheet Functions 3 December 14th 05 02:11 AM
autopopulate sl.no.based on a cell value TUNGANA KURMA RAJU Excel Discussion (Misc queries) 3 October 21st 05 07:44 AM
autopopulate date [email protected] Excel Discussion (Misc queries) 8 October 6th 05 03:29 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017