alinac
01-18-2021, 09:09 AM
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
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