Hi,
I need a macro to insert a nominal code which depends on the value in a cell. This is to follow the text contents of two other cells (names) and the date contents of two more cells. The end result will be in one cell with comma separating giving:-

Name1,name2, date1-date2, nominal code


If cell value is 2, then nominal code is 4601
If cell value is 4, then nominal code is 4502
If cell value is 6, then nominal code is 4503
If cell value is 8, then nominal code is 4501

I am working on the easier bits but if anybody has time to help it would be much appreciated.

Budgie

--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to