D
daphoenix
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
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