Hi,
I'm looking for a solution for this case scenario.
I have an excel file with in a column some names and some csv files, named with same names.
I'm trying a way to extract the rows from the excel file and append them to the proper csv file.
For example, Excel file:
Name,Col2,Col3,Col4
Pippo,x,x,x
Pippo,y,y,y
Pippo,z,z,z
Pluto,a,f,b
Pluto,a,g,b
And following csv files:
Pippo.csv
Col2,Col3,Col4
a,b,f
x,b,v
Pluto.csv
Col2,Col3,Col4
y,s,b
y,s,g
Result should be
Pippo.csv
Col2,Col3,Col4
a,b,f
x,b,v
x,x,x
y,y,y
z,z,z
Pluto.csv
Col2,Col3,Col4
y,s,b
y,s,g
a,f,b
a,g,b
My knowledge of VBA is 0, but I can try to work on it if it's possible to solve this case.
I'm fine also to buy an add-in if exists.
Thanks
I'm looking for a solution for this case scenario.
I have an excel file with in a column some names and some csv files, named with same names.
I'm trying a way to extract the rows from the excel file and append them to the proper csv file.
For example, Excel file:
Name,Col2,Col3,Col4
Pippo,x,x,x
Pippo,y,y,y
Pippo,z,z,z
Pluto,a,f,b
Pluto,a,g,b
And following csv files:
Pippo.csv
Col2,Col3,Col4
a,b,f
x,b,v
Pluto.csv
Col2,Col3,Col4
y,s,b
y,s,g
Result should be
Pippo.csv
Col2,Col3,Col4
a,b,f
x,b,v
x,x,x
y,y,y
z,z,z
Pluto.csv
Col2,Col3,Col4
y,s,b
y,s,g
a,f,b
a,g,b
My knowledge of VBA is 0, but I can try to work on it if it's possible to solve this case.
I'm fine also to buy an add-in if exists.
Thanks