Hi,

I have a spreadsheet "lw1" with 25,000 rows and 21 columns.

Most of column C is usually blank.
But when column C is not blank, I would like to:

1. Grab columns A, B, C, G, H, J and K from all the rows
where column C is not blank.

2. Display these rows in a pop-up window.

3. With the column headings "1st", "2nd", "3rd", "4th",
"5th", "6th", "7th".

4. Add a (new) last column to pop-up window
called "calculated".

5. Where "calculated" is C+(C*G)+J in each row.

6. As soon as the user clicks on the "OK" button in the
pop-up window, I would like to save the contents
of the pop-up window into a csv file.

Can you give me the VBA code for this so that I can add it to
button?

Thanks,
Luthe

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com