Insert Row on Multiple Sheets - Copy Formulas

Hi all,

I'm new to the forum and have searched and found similar problems, but no solution meets my specific need. I have 3 sheets in a workbook which all follow an identical format (customer name in column A, and months in columns to the right (currently B through P - but this will increase with time). All of the names across the 3 sheets are in an identical order, but whenever I need to add a customer (which would be accomplished through inserting a row), I would like the other two sheets to update with the same customer name and copy the formulas in column B and right down one row to the newly inserted row. One caveat, the formula that the macro would copy is one that I created (it is not standard in excel - the formula adds only BOLD numbers)...

My sheet names are "Done & In CORD" "Done Not Received" and "Opportunity"

Here was my first crack at it...

Please Login or Register  to view this content.

Thanks for the help!
-Matt

1. No, the customer could be added anywhere throughout the list (any row) Ideally the customers would be in alphabetical order. It may be the bottom, but not necessarily.
2. Yes, the row needs to go exactly where it went (on whichever sheet the row was inserted on)
3. Not for any reason other than I probably messed it up.. I'm not that great at macros as you can see...
4. A userform would be GREAT and I agree it would work nicely.

One last comment, the customers are obviously not Customer 1, 2, 3 etc.. They would be Names, not Numbers.