this might be tricky and i dont know of this is possible but i guess it is
worth a shot to put up here.
scnerio:

i have 5 cells between category titles in column A. first title in cell a1
and second title in a7, so the 5 cells would be between a1, and a7. Each one
of those cells(a2:a6) uses a VLOOKUP function to another workshhet and
returrns a value. not all these cells are filled, some are left blank. For
example there are 5 cells and 3 are filled because of the Vlookup, I want to
keep the three values, and have excel reformat the space inbetween cells a2
and a6 to three equally sized cells....

but then also do that same procedure column A:G

see your other post!

--

Regards,
Nigel
(E-Mail Removed)



"daphoenix" <(E-Mail Removed)> wrote in message
news:696559B1-DB2F-4AB3-96CB-(E-Mail Removed)...
> this might be tricky and i dont know of this is possible but i guess it is
> worth a shot to put up here.
> scnerio:
>
> i have 5 cells between category titles in column A. first title in cell a1
> and second title in a7, so the 5 cells would be between a1, and a7. Each
> one
> of those cells(a2:a6) uses a VLOOKUP function to another workshhet and
> returrns a value. not all these cells are filled, some are left blank. For
> example there are 5 cells and 3 are filled because of the Vlookup, I want
> to
> keep the three values, and have excel reformat the space inbetween cells
> a2
> and a6 to three equally sized cells....
>
> but then also do that same procedure column A:G
>
>
>
>
>

but there is nothing there

"Nigel" wrote:

> see your other post!
>
> --
>
> Regards,
> Nigel
> (E-Mail Removed)
>
>
>
> "daphoenix" <(E-Mail Removed)> wrote in message
> news:696559B1-DB2F-4AB3-96CB-(E-Mail Removed)...
> > this might be tricky and i dont know of this is possible but i guess it is
> > worth a shot to put up here.
> > scnerio:
> >
> > i have 5 cells between category titles in column A. first title in cell a1
> > and second title in a7, so the 5 cells would be between a1, and a7. Each
> > one
> > of those cells(a2:a6) uses a VLOOKUP function to another workshhet and
> > returrns a value. not all these cells are filled, some are left blank. For
> > example there are 5 cells and 3 are filled because of the Vlookup, I want
> > to
> > keep the three values, and have excel reformat the space inbetween cells
> > a2
> > and a6 to three equally sized cells....
> >
> > but then also do that same procedure column A:G
> >
> >
> >
> >
> >
>

One of the problems of multi posting is you never know where the answers
might be!

--

Regards,
Nigel
(E-Mail Removed)



"daphoenix" <(E-Mail Removed)> wrote in message
news:049D0B94-1D0B-457F-8D07-(E-Mail Removed)...
> but there is nothing there
>
> "Nigel" wrote:
>
>> see your other post!
>>
>> --
>>
>> Regards,
>> Nigel
>> (E-Mail Removed)
>>
>>
>>
>> "daphoenix" <(E-Mail Removed)> wrote in message
>> news:696559B1-DB2F-4AB3-96CB-(E-Mail Removed)...
>> > this might be tricky and i dont know of this is possible but i guess it
>> > is
>> > worth a shot to put up here.
>> > scnerio:
>> >
>> > i have 5 cells between category titles in column A. first title in cell
>> > a1
>> > and second title in a7, so the 5 cells would be between a1, and a7.
>> > Each
>> > one
>> > of those cells(a2:a6) uses a VLOOKUP function to another workshhet and
>> > returrns a value. not all these cells are filled, some are left blank.
>> > For
>> > example there are 5 cells and 3 are filled because of the Vlookup, I
>> > want
>> > to
>> > keep the three values, and have excel reformat the space inbetween
>> > cells
>> > a2
>> > and a6 to three equally sized cells....
>> >
>> > but then also do that same procedure column A:G
>> >
>> >
>> >
>> >
>> >
>>