I wish I knew how to ask this - but I just don't know the terminology. I have
been using excel to create estimates and invoices for many years. Also for
many years, I've wished I could create a way for the estimate/contract to
"auto-expand" as I type in row after row of product description - quantity -
unit price - totals and so forth. I want this because there is lots of text
after the product listing, and right now I have to hide rows or add rows
according to my needs. I link the cells on my actual printable estimate to
another series of sheets where I calculate my costs and markup. I've asked
many people over the years how to do this, but no one ever can give me an
answer - though I've seen spreadsheets that work the way I want (I just don't
know how to get in touch with the authors!). I understand this may be a
macro/VBA issue but If someone out there could even just point me in the
right direction I would appreciate it.