S
sjharri
I have a macro that generates a csv file from a number of different csv
files. I would like to add a row and number each 1,2,3...... etc.
These are going to be column headings in the csv file, which is then
going to be imported into a database.
I would like to be able to add this column and number it incrementally
up for all columns containing data.
For example; One spreadsheet might contain 7 columns of data therefore
I would like to insert a row and insert the vaules 1-7. However the
next spreadsheet might contain only 3 columns of data therefore I would
like the macro to insert a row and only populate the first 3 cells with
1-3.
Is this possible?
Thanks
Steve
files. I would like to add a row and number each 1,2,3...... etc.
These are going to be column headings in the csv file, which is then
going to be imported into a database.
I would like to be able to add this column and number it incrementally
up for all columns containing data.
For example; One spreadsheet might contain 7 columns of data therefore
I would like to insert a row and insert the vaules 1-7. However the
next spreadsheet might contain only 3 columns of data therefore I would
like the macro to insert a row and only populate the first 3 cells with
1-3.
Is this possible?
Thanks
Steve