Adjusting Table Size As Needed

[ALdair]

I'm working on a project that needs a bit of flexibility in it.

I'm building a table that can potentially expand and contract greatly depending on what the user needs. I've figured out how to make columns expand and collapse laterally to meet my needs (getting it done without manually refreshing the page is a bear but not my issue right now). I am stumped at trying to figure out how to automatically update a row with the formatting of the row above it when you enter in a name to a cell.

Basically:

Formatted Row: Name Name PII PII Data Data Data Data
Empty Row: Empty Empty Empty Empty Empty Empty <- Need this row to copy formatting of the row above when I enter a name

 

[AFPathfinder]

Try Inserting a row right below the last used row. The insert action typically copies the format from left or above by default (depends on what you're inserting; column or row).

Otherwise, you might be looking into a VBA solution.

    Selection.Offset(-1).Copy
    Range("A8").PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False