Sample work of automation done using VBA in excel
Sheet named Ques1_Ans has answer to below mentioned question: Using the attached workbook and worksheets “Ques1_Ans.” Create legends using checkboxes on to the ChartObject which displays sales of 7 products. Once this legends are checked or unchecked the line on corresponding line on the chart should be hidden from the chart. Sheet named Ques2_Ans has answer to below mentioned question: Using the Survey Date sheet provided in attached workbook. Calculate Following by creating a pivot table: Number of males and females who find the store hours are convenient % of males to females who find the store well maintained. Both the answers were automated in excel macros using VBA. Please free to ask for more samples of automation done using VBA.
About Me
I had 1.5 yrs experience in reporting & preparing dashboards . Automating excel work(reports or dashboards) using VBA macros.
NEW FREELANCER!
