Budgeting macros

Can you explain your process?

For instance:
1) Enter a $ amount D3
2) $ amount entered parses itself out to the table in column B based on percentages already entered into each cell.
3) Something else appears in column D?
4) Pressing SUBMIT enters the amounts that appeared in the table to the various envelopes and table resets

Can you provide all of the "percentages" for the table? Fill out a sample entry amount with all the values, perhaps based on a $100 total allocation.

Also, if you make sure the contents of the "envelope" names exactly matches the table, then a macro can find those cells whereever you move them to in the future allowing you to have flexibility with your layout. That means no hard-coded returns. Just put "Children: Diapers" into both the table and the envelopes.

If you want wrapping on the envelopes, set WRAP TEXT in the format cells for those cells.