L
lothario
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
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