has anyone got a quick bit of code that will enable me to split an expense item into three separate items if i select "Yes" from a validation list at the end of the data input? I am trying to do a quick fix for a colleague in accounts payable who wishes to split some of the petty cash transactions across three departments. I thought, add the validation list to each line (col K), then use a worksheet change event to copy the amount to a helper cell, insert the extra three lines, mark them with a flag to signify already split, split the amount and input into the three new lines, remove the existing line, and then have a cup of tea. have i missed anything? i figure I will also have to have a way for the user to be able to revert the three new lines back to a single entry if need be. it would be awesome if anyone has done this before and doesn't mind sharing. ideas, suggestions, solutions are all welcome.