Please refer to attachment. I currently have a realtively large data set approximately 500 line items. In the format as shown in the sheet titled 'Current format' and i need it in the format as per sheet 'desired forma'. Is there a way to automatically change the format, rather than individually rearranging the fields

Hi

See the attached workbook. A simple solution using drop-down lists and the SUMPRODUCT function.

Hope you like it

To learn more bout drop-down lists and SUMPRODUCT visit my website at:

http://www.excel-vba.com