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




"daphoenix" wrote in message
...
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




"daphoenix" wrote in message
...
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




"daphoenix" wrote in message
...
but there is nothing there

"Nigel" wrote:

see your other post!

--

Regards,
Nigel




"daphoenix" wrote in message
...
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