Here's an accounting Excel question... So we get a data dump from an inventory system that we would like to put into an Excel document and create a template to upload to our accounting software. From the inventory data dump we would like to be able to convert certain line items into many, but some will stay one to one. For example: Inventory #3 - $100 - Property 10 will remain the same (because Property 10 does not get allocated) Inventory #3 - $100 - Property 7 becomes the following line items: Inventory #3 - $50 - Property 7.1 Inventory #3 - $50 - Property 7.2 Hopefully that makes some sense. I'm not sure if this should be done through a macro or what. Thanks.