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 ...