Here is a macro that will delete Sheet 2 and Sheet 3 from one file and then move the remaining worksheet from that file into another file called master.xls. Hope someone finds this useful one day.
Sub deletemove()
‘ deletemove Macro
‘ Keyboard Shortcut: Ctrl+l
Sheets(“Sheet2”).Select
ActiveWindow.SelectedSheets.Delete
Sheets(“Sheet3”).Select
ActiveWindow.SelectedSheets.Delete
ActiveSheet.Select
ActiveSheet.Move Before:=Workbooks(“Master.xls”). _Sheets(1)
End Sub
I would love to get your feedback on my picopause articles in this very short survey.
If you enjoyed this article and would like to get updates from shaneycrawford dotcom sent to your inbox, click here to subscribe. It’s free!
I write about…
addiction amends android anxiety apps artificial intelligence attention authenticity beliefs books Canada chrome climate change coaching commitment conflicts consistency decisions defensiveness devices disasters disruption doubt education email emotional intelligence evernote facebook fear feedback feelings food addiction Fukushima games gmail google gratitude hardware humility Ibaraki insecurity integrity intercultural understanding itunes Japanese language tests judgement kanji leadership learning Japanese learning languages library & information science listening living in Japan living in reality movies ms office music patience perfectionism pets photos podcasts procrastination productivity purpose questions quiet time racism recipes recovery relationships right-sizing serenity sexism simplicity social issues software sports square dancing subscriptions surrender teaching English teaching Japanese Tokyo translation travel Tsukuba ubuntu United States values videos volunteering web design weight loss wellbeing willingness windows wordpress workaholism youtube
Search
Browse Archives
Leave a Reply