auto adjusting cell size and row height

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
 
N

Nigel

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

--

Regards,
Nigel
(e-mail address removed)
 

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

Top