jamiepatrick
New Member
- Joined
- Feb 11, 2016
- Messages
- 1
Hi,
I am not brilliant with coding so apologies if this seems really simple.
Within our FoxPro based system we have an export to excel feature which currently exports data to a csv format. What I am hoping to do is create a macro that will insert a new line into row 1 (moving the data down a row) and add a specific header for each column. I would then like the spreadsheet to find out which is the last row with any data in and in the row below I would like columns M and O to autosum the totals for their column.
Any help with this would be massively appreciated.
Kind Regards,
Jamie
I am not brilliant with coding so apologies if this seems really simple.
Within our FoxPro based system we have an export to excel feature which currently exports data to a csv format. What I am hoping to do is create a macro that will insert a new line into row 1 (moving the data down a row) and add a specific header for each column. I would then like the spreadsheet to find out which is the last row with any data in and in the row below I would like columns M and O to autosum the totals for their column.
Any help with this would be massively appreciated.
Kind Regards,
Jamie