Pete
07-20-2008, 06:25 AM
See attached workbook.......
Hi
Need to add a extra step to the current macro button in worksheet "Volume Summary", when the user adds or clicks the macro button "Refresh & Update Data Fields".
I want the macro to add defined name ranges from column F:EC for all the tables in the worksheet...and also to update when a new client name is added to the worksheet "Deal Selection" and then the user returns back to the workhseet "Volume Summary" at click the "Refresh & Update Data Fields" - macro button......
so altogether there are six tables in the volume summary worksheet....
i believe that a similiar function to hightlighing columns E:BC and then the user selects CTRL + SHIFT + F3 which allows you to set name ranges should do the trick.........
Hi
Need to add a extra step to the current macro button in worksheet "Volume Summary", when the user adds or clicks the macro button "Refresh & Update Data Fields".
I want the macro to add defined name ranges from column F:EC for all the tables in the worksheet...and also to update when a new client name is added to the worksheet "Deal Selection" and then the user returns back to the workhseet "Volume Summary" at click the "Refresh & Update Data Fields" - macro button......
so altogether there are six tables in the volume summary worksheet....
i believe that a similiar function to hightlighing columns E:BC and then the user selects CTRL + SHIFT + F3 which allows you to set name ranges should do the trick.........