I need help creating an invoicing macro, as I am new to Vba. It needs to create a new invoice(sheet) based of every unique value in column A while adding the corresponding datas. Rows can differ, it should work for 1 row or 1000. Each invoice must have the same invoice date & due date, otherwise macro should stop to avoid error completion. "Data" sheet can be rearranged per your desire if transpose method is being used for copy(completion). New sheet can be added if you'd filter to filter/copy datas there
I hope this is not something too hard and you guys can help me!