range referencing

L

lakey13

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba code to filter the data like a group with group header 5
How to get groups to be across, but details to be down within group? 1
range referencing 1
Compare Names in a column and create single list with adjacent vla 6
Transpose macro 2
Removing unnecessary rows through macro 6
Looping help needed 13
Duplicate in A copy value in B (loop?) 2

Top