hi All,

I am not an expert in VBA but knows some basics. I have a list of invoice numbers for a number of customers. I have a macro created to create an invoice format for each invoices and create and save new excels based on invoice numbers. I am looking for a macro code to loop through one customers invoices, and create all invoices in one workbook.

The first time when a condition is met, I would like the macro to create a workbook and second time onwards it should create sheets in to that workbook.

example: until range("A2") = " " I want the macro to run a loop. If the first time condition is not met i want to create a new workbook and copy information. and then onwards i want to have a sheet created in the same workbook and copy info.

can I get some help please.

Thank you
Anish