I've been tasked with taking a system design tool and exporting the data in a specific format. It should be fairly easy but I'm completely new when it comes to macros. Basic objective is as follows:
We have a 3 column worksheet with headers. Item, QTY, external id. I need to loop through each row, if column a (item) is blank, don't include the row in the export. Once it's finished the loop, it should export the worksheet as a csv file (with specific header names specified in the code). Ideally, this would be done on a button click on the worksheet. I've found several examples of macros that delete rows with empty cells, create a csv file from a worksheet, but non that really combine these.
The other important part is it should NOT alter the excel file / worksheets in any way. Just create the correctly formatted csv file.
Any help starting or pointing me in the right direction would be greatly appreciated. Let me know what other information I could provide that would help.
We have a 3 column worksheet with headers. Item, QTY, external id. I need to loop through each row, if column a (item) is blank, don't include the row in the export. Once it's finished the loop, it should export the worksheet as a csv file (with specific header names specified in the code). Ideally, this would be done on a button click on the worksheet. I've found several examples of macros that delete rows with empty cells, create a csv file from a worksheet, but non that really combine these.
The other important part is it should NOT alter the excel file / worksheets in any way. Just create the correctly formatted csv file.
Any help starting or pointing me in the right direction would be greatly appreciated. Let me know what other information I could provide that would help.