Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-779019%22%20slang%3D%22en-US%22%3ENeed%20to%20remove%20columns%20and%20save%20file%20with%20a%20name%20ends%20with%20today%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779019%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20a%20repeated%20task%20very%20frequently%20and%20I%20am%20trying%20to%20see%20whether%20I%20can%20automate%20the%20process.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20few%20products%20and%20I%20need%20to%20order%20those.%20I%20create%20an%20excel%20spreadsheet%20and%20I%20create%20columns%20as%20product%20name(first%20column)%20and%20multiple%20vendors(%20three%20different%20columns).%20I%20have%20many%20different%20products%20as%20rows.%20Once%20I%20work%20on%20where%20to%20order%20product%20then%20I%20have%20lot%20of%20rows%20of%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20want%20to%20place%20the%20order(for%20eg%20vendors%20a%2C%20b%2C%20c)%20then%20I%20remove%20columns%20b%20and%20c%20and%20save%20the%20file%20as%20a_%3CTODAYDATE%3E.xls.%20I%20create%20another%20file%20as%20b_%3CTODAYDATE%3E.xls%20by%20removing%20columns%20a%20and%20c.%26nbsp%3B%3C%2FTODAYDATE%3E%3C%2FTODAYDATE%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20automate%20remove%20columns%20and%20creating%20a%20file%20name%20%3F%20Macro%20can%20do%20this%20or%20any%20other%20suggestion%20in%20excel%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAutomation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERepeatingTasks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Srini Sanagapalli
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 ?

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies