I have an excel sheet from which i would like to import the values into a csv..I want this to be automated(it should happen at an end of day basis)..so i just created a csv file and recorded a macro and imported the data from my excel sheet...However csv's dont have macro capability.So now basically my recorded macro is useless ...any suggestions would be really helpful.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…