I need some help in writing vba code in Excel 2010.I am a novice at coding. I inherited a macro that let the user select a factory from a drop down menu. After user makes a selection, a button is click to execute the macro. The macro does a series of copying and pasting data to update a series of charts. Then all sheets are hidden except the sheet containing the charts. The charts sheet then saved to a separate folder with a different name on network and it closes. The problem is that the user has to individual select about 60 factories and run macro. This is very time consuming. I am looking for help in constructing a VBA code that let the user run the macro with one click of a button. I still need to be able to hide all datasheets after copying and pasting the data for each factory except for the chart and save each factory with it unique name.
Bookmarks