Extracting data into a CSV file

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top