Need use vba to arrange data, export as .csv - No clue where to start

Hi. I have attached the spreadsheet i am working with.
I need to be able to manually enter device quantities into the properly labeled column,
then need to export only certain columns in a specific configuration to a csv file,named with
the project name .


There will only be three columns in the csv. Line #, SCN (which is part number), and Quantity, which
is shown for reference on the second tab of the workbook.

Culd someone point me in the right direction please?

Try

Please Login or Register  to view this content.

Thank you! This works perfectly. Is there a way to exclude lines that have a zero quantity?

https://officemastery.com/_merge-and...r-alternative/

Brilliant! Didn't know this, glad I do now. Thanks.