I would like to place a button in an Excel spreadsheet that will run a macro. I already know how to create a macro, and I intend to use the same workbook over & over each month. I also need to know more about storing macro's in the worksheet. This macro will go to a specific directory, open a specific file, manipulate, copy & paste that file into this spreadsheet, update the pivot table and populate other sheets throughout the entire workbook. I would like to place buttons on all the worksheets that contain data, around 12 sheets. These sheets then populate 3 reports that are due the first week of the month.
2006-09-13
10:19:49
·
3 answers
·
asked by
Sunny_1_
3