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 ?