C
Constantly Amazed
Hi
I am using Excel 2003 and need to create a CSV file from data entered on an
Excel spreadsheet acting as a template.
What I need to achieve is that a variable number of rows of data will exist
starting at A3. I need to check that for each of these rows there is an
entry in columns A,C,D,E and F (ie the cells are not blank).
Having checked that all the necessary data is present (it would be good if
the user got a warning message if any of the cells were blank) I need to
build the 5 pieces of data into a CSV file with each piece of data enclosed
in double " marks and line return after for the next set. It would also be
very useful if the user could give each CSV file a name and input the
destination to save it to.
Of course I could just build the data strings up using normal concatination
formulas but then I still need advise on selecting the range containing valid
data strings and extracting this as a CSV file and saving the data with a
user defined file name and destination.
As always I appreciate your kind assistance.
G
As always
I am using Excel 2003 and need to create a CSV file from data entered on an
Excel spreadsheet acting as a template.
What I need to achieve is that a variable number of rows of data will exist
starting at A3. I need to check that for each of these rows there is an
entry in columns A,C,D,E and F (ie the cells are not blank).
Having checked that all the necessary data is present (it would be good if
the user got a warning message if any of the cells were blank) I need to
build the 5 pieces of data into a CSV file with each piece of data enclosed
in double " marks and line return after for the next set. It would also be
very useful if the user could give each CSV file a name and input the
destination to save it to.
Of course I could just build the data strings up using normal concatination
formulas but then I still need advise on selecting the range containing valid
data strings and extracting this as a CSV file and saving the data with a
user defined file name and destination.
As always I appreciate your kind assistance.
G
As always