Hello Team,

I am trying to create a macro that will search in a particular column in an excel file, let's say column A for the text values as below.

In the column we have a row with text Invoice 1 then one or more lines with Item 1, Item 2, Item3....etc. Then we have Invoice 2 folowed by Item x, Item y.....

For each Invoice, we need to create a new .xls file named with the Invoice number, in which I need to copy the items for that invoice on column B.
Can you please help me with some ideas?

Thank you in advance,

Ina