Need to remove columns and save file with a name ends with today date

Occasional Contributor

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 ?

0 Replies