I have the attached Excel file as sample:
The sheet "Project" includes 2 named range: Header and Footer that delimitate the area of the table in between. Let's say there are x columns and y rows. x and y are not limited you get to know the area by having Header and Footer that delimitate the table. In case you add or delete rows it should not be affected.
1. I need a macro triggered by button click on the sheet
The macro should run through each row and column and output to file.
2. If you select in Excel some of the cells in column j
Only the rows that have a selected cell should output to file. Multi-selection should be supported.
Append the cell values in a csv file like:
"John", "Smith", "100", "10-12-2012"
the destination file absolute path can be defined in one of the excel cells on a different sheet named "Configuration" see B1 for example.
4. Alert after work is done should show the number of rows that were processed and after clicking ok on the alert it should un-select the cells in Excel
That's it - it's been a long since I've worked with VBA so I prefer use the Experts on this one!! :)