Macro to change data entered in a cell seperated by a comma, into a vertical list of data

i have data that is entered in the "data" sheet of a workbook, that i need transformed into the format on "sheet 1". Multiple invoices are listed in column E seperated by a column with their respective amounts listed in column F also seperated by a column. Inorder for me to input this data into my accounting software, i need each invoice with the ammount it is paying on its own row. Also, column K on "sheet 1" need to count the number of invoices entered, and if the total paid on invoices column added up for a custmer does not equal the amount of the check, i need all the amounts highlighted. Any suggestions on this will be appreciated, as it takes me roughly 6 hours to enter all that data manually. There is a range of the amount of checks that i need to input from 4 - 500, i just gave an example using 4.

Thank you so much

Thank Mike, this is perfect. As far as the fields that you had to hardcode, i dont need the ENTERED? column. Also, i cant change the amount entered in column D on the data tab. What i wanted was a way to indicate if the amounts entered in column F of the data tab did not equal the amount entered in column d of the data tab - whatever way you can make that indication is fine with me even if you have to add a validation column.

Thanks so much for your quick response - this is awesome!

yes you are 100% correct.

the difference column is perfect. Can you remove the Entered ? column (i do not need it). And i noticed if there are 3 invoice numbers and 2 invoice amnts, the macro will error out. If it is easy for you to display a pop up box that shows where the error occured can you add it. If not, i understand. BUT this is perfect!! Thank you

those two fields are manually entered, so yes - there is the opportunity for error both ways

Yes, that is it

Mike, you are offically a life saver!!! -- THIS IS PERFECT