O onklus New Member Nov 28, 2010 #1 When I open a new worksheet in Excel 2007 and click on 'Macros' under the 'Developer' tab excel will not let me create a new marco. The 'create' button (and all other buttons) are grayed out. Any suggestions? Thanks
When I open a new worksheet in Excel 2007 and click on 'Macros' under the 'Developer' tab excel will not let me create a new marco. The 'create' button (and all other buttons) are grayed out. Any suggestions? Thanks
K keymaster New Member Nov 28, 2010 #2 Start typing a name for your macro, you will see that the create button will be enabled.
O onklus New Member Nov 28, 2010 #3 Thanks. I actually previously created a macro. When I go to the VBA editor the code is there, but when I go to run the macro in excel I don't see the macro (it's not available as an option. In the VBA editor the code is associated with an object (the worksheet that I want the macro to run on. Any suggestions?
Thanks. I actually previously created a macro. When I go to the VBA editor the code is there, but when I go to run the macro in excel I don't see the macro (it's not available as an option. In the VBA editor the code is associated with an object (the worksheet that I want the macro to run on. Any suggestions?
S SamirQ New Member Nov 29, 2010 #5 Hello, I have two similar lists with date fields. One is a test list and the other is a master list. I need to macro to copy all values in the test list from a particular date onwards and paste/overwrite in the master list. Any help will be appreciated.
Hello, I have two similar lists with date fields. One is a test list and the other is a master list. I need to macro to copy all values in the test list from a particular date onwards and paste/overwrite in the master list. Any help will be appreciated.
Hui Excel Ninja Staff member Nov 29, 2010 #6 SamirQ Firstly: Can you please start a new post, so that people don't get confused about which question your refering too? To post a new question goto: http://chandoo.org/forums/forum/ask-excel-questions#postform Can't you convert the test list to a Table, apply selection criteria and sort and copy the relevent cells to the master table
SamirQ Firstly: Can you please start a new post, so that people don't get confused about which question your refering too? To post a new question goto: http://chandoo.org/forums/forum/ask-excel-questions#postform Can't you convert the test list to a Table, apply selection criteria and sort and copy the relevent cells to the master table