range referencing

From: lakey13 (lakey13.1fgn8p_at_excelforum-nospam.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 09:38:38 -0600

ok,

here's what i have

two columns of information, the first column has one word in a col and
nothing in b col. i was trying to select the area on the page since
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 just
fill in the blanks on column a with the cell directly above it and then
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 group2 

-- 
lakey13
------------------------------------------------------------------------
lakey13's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15997
View this thread: http://www.excelforum.com/showthread.php?threadid=275660

Relevant Pages

  • Re: Nested Security Groups in Mail enabled security groups
    ... > to group1 all users get the message. ... I create another group called group2 ... > Every position is a security group, every sub departement is a security ... > group and every department is a security group and all of the groups are ...
    (microsoft.public.exchange.admin)
  • Nested Security Groups in Mail enabled security groups
    ... Windows 2003 native domain with Windows 2003 native forest, ... to group1 all users get the message. ... I create another group called group2 ... Every position is a security group, every sub departement is a security ...
    (microsoft.public.exchange.admin)
  • Re: Looping over a query
    ... I need to loop over the results because they are being inserted into another ... Insert Into @UniqueGroupNames Values (@Group1) ... Insert Into @UniqueGroupNames Values (@Group2) ...
    (microsoft.public.sqlserver.programming)
  • Re: Problems with GPO
    ... I see that you applied that to Group1 and Group2 and thatz fine. ... The policy you applied should not affect other users even if thatz ...
    (microsoft.public.windows.server.active_directory)