range referencing
 

ok,

here's what i have

two columns of information, the first column has one word in a col an
nothing in b col. i was trying to select the area on the page sinc
these names and groups change with every different file i bring in.
excel seems to "hard code" in the range selected. i need it to jus
fill in the blanks on column a with the cell directly above it and the
paste the values to column a.

tia... lakey :confused:

what i have
=========
name1
group1
group2
group3
name2
group1
group2
group3
group4
group5
name3
group1
group2

what i need
========
name1
name1 group1
name1 group2
name1 group3
name2
name2 group1
name2 group2
name2 group3
name2 group4
name2 group5
name3
name3 group1
name3 group

--
lakey1
-----------------------------------------------------------------------
lakey13's Profile: http://www.excelforum.com/member.php...fo&userid=1599
View this thread: http://www.excelforum.com/showthread.php?threadid=27566