QuintonMcCloud
New Member
Hi Guys
I am currently struggling with coming up with a formula for VBA that will actually copy data in a specific column based on the current month or at the end of the month. Basically this workbook needs to be able to contain data that is reviewed at the end of the month but then it can only be viewed as a .csv file. What I had been able to do is to create a macro that does copy manually selected data, opens a new .csv file and then pastes the data into that .csv file, it opens the print page and then it also opens a new email page to send or to forward the file to anyone else, However my biggest downfall with this is that I have done recorded my macros instead of coding them.
Please Help ...pretty please ...I have attached the workbook with the worksheets that I want to to be printed and emailed ...actually there is one more thing..the .csv file that I create with my macro collates every material type and quantities together onto one worsheet arranged in columns with a column apart each material and its quantity.
Thank you for taking you time to read through this...
I am currently struggling with coming up with a formula for VBA that will actually copy data in a specific column based on the current month or at the end of the month. Basically this workbook needs to be able to contain data that is reviewed at the end of the month but then it can only be viewed as a .csv file. What I had been able to do is to create a macro that does copy manually selected data, opens a new .csv file and then pastes the data into that .csv file, it opens the print page and then it also opens a new email page to send or to forward the file to anyone else, However my biggest downfall with this is that I have done recorded my macros instead of coding them.
Please Help ...pretty please ...I have attached the workbook with the worksheets that I want to to be printed and emailed ...actually there is one more thing..the .csv file that I create with my macro collates every material type and quantities together onto one worsheet arranged in columns with a column apart each material and its quantity.
Thank you for taking you time to read through this...