Why not try data Validation, assuming that you have a list of customers in
the sheet. Debra Dalgleish has great articles on Datathis subject. Start with:
http://www.contextures.com/xlDataVal01.html
Peter
"WH99" wrote:
I have a time sheet, the first six columns are headed as follows:
Hours Hours worked for company
Start time End time A B C D
18:00 03:00 09:00
18:00 03:00 09:00
Having inserted the Start and End times, I need a message box to pop up and
ask "which company to bill" and which ever is selected (by a option button)
the total would be inserted on the correct cell of the row your working on.
--
WH99