Macro to print and create a .csv

Firstly, just to clarify, as your file was called - Uni work.xlsm Ive assumed this is some kind of assignment therefore Im more than happy to give pointers but not solutions

Originally Posted by QuintonMcCloud

Print- to create a button that allows the user to be able to click it and print all of the filled areas on all of the worksheets. As you will see each data is stored in columns therefore it would be beneficial either for the print macro to automatically include the new column or to just set it to include all columns of this year, however how about next year as well is the question that I am struggling with.

The answer to this depends on how you would decide which data is to be shown, for example, if you only want to show data for previous months (ie running it now would show columns A-K) then you can calculate the allowable columns using a calculation based on todays date. for instance take the current year and deduct 2015 from it, multiply that by 12 and then add on the current month. So todays would be (((2015 - 2015)* 12) + 8) which would give 8, therefore set your range to be your 4 initial columns plus this 8.

Originally Posted by QuintonMcCloud

Export- to create a button that when clicked the user can create new .csv files all in one workbook, one worksheet all on one page. or if the easiest which I found is to create a macro for each material type however this is onerous and is a pain to then fix if they do go wrong, unless I think I am using the wrong formula.

Can you confirm what exactly is meant by the highlighted bit?