Formula for merging cells/re sizing cells

  • Thread starter Thread starter Mathicas
  • Start date Start date
M

Mathicas

Hey all,

I have a data entry sheet that I wish to use to create a visual stcaking
plan. (It's a visual representation of which tenants are occuping a certain
floor or space in a building.)

So, right now, I'm inputting a square footage on one page and auto merging
cells on the other page based on the size of the space. Is there any formula
that will automatically merge cells based on a number (the square footage) so
that it will be an accurate representation of the space?
 
Nope. Formulas return values to cells. The do not modify the size or shape of
cells. Conditional formatting can modify the format of a cell but that is a
long way from what you are trying to do...

You could create a macro, but macros and merged cells don't get along...
 
Back
Top