Automate your tasks with the Automate tab—now in Excel for Windows and Mac
The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web.
Need to remove columns and save file with a name ends with today date
I do a repeated task very frequently and I am trying to see whether I can automate the process. I have few products and I need to order those. I create an excel spreadsheet and I create columns as product name(first column) and multiple vendors( three different columns). I have many different products as rows. Once I work on where to order product then I have lot of rows of data. When I want to place the order(for eg vendors a, b, c) then I remove columns b and c and save the file as a_<todaydate>.xls. I create another file as b_<todaydate>.xls by removing columns a and c. How can I automate remove columns and creating a file name ? Macro can do this or any other suggestion in excel ?Dynamic linked tables
I'm attempting to create a master table of projects linked to smaller tables with subsets of the data that update automatically. For example, if Table 1 contains a master list of projects with associated data, Table 2 could show all of the projects in Antarctica. Is it possible to link these tables in such a way that when I update the master list with a new project in Antarctica, Table 2 automatically expands to include that project and its data? Currently I'm accomplishing this by filtering Table 1, manually copying the data I want, and then pasting in a new sheet to create a separate table. I would love to automate this ...
