+ Reply to Thread
Results 1 to 3 of 3

Excel help usingf VBA macro code and sort functionsd

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    Dallas, Texas
    MS-Off Ver
    windows 2013
    Posts
    72

    Excel help usingf VBA macro code and sort functionsd

    Every Morning I have to go download multiple excel files with data and import them into a document. I proceed to delete columns while renaming and moving them as well. I then have to do a time difference and then sort by a certain column and delete every row with a certain value. Then do this again with another column. I then put a title then sort again and delete everything in a column that is under x time. I was wondering if there would be anyway to automate this, so that I would just be able to import then press a button. I am not very good at coding or macros, just wanted to know if this was even possible so that I could look into it. Thank You
    Last edited by Tgbell; 06-26-2019 at 01:57 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Excel macro for automating daily task

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Excel help usingf VBA macro code and sort functionsd

    It's certainly possible, and the macro recorder would give you a start on the code you need.

    Some quality time spent reading http://www.cpearson.com/excel/DebuggingVBA.aspx would be rewarded.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automating a task
    By kadz1993 in forum Excel General
    Replies: 1
    Last Post: 07-27-2015, 10:27 AM
  2. Need Excel daily Task tracker template
    By fzzd2x in forum Excel General
    Replies: 0
    Last Post: 09-26-2012, 09:37 AM
  3. Automating a Person-To-Task Distribution Process using Excel.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2011, 09:44 AM
  4. Automating a task between two files
    By qqqqqqqq in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-12-2010, 10:52 PM
  5. Automating an editing task
    By dwtaxguy in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-26-2009, 02:16 PM
  6. Advice on Automating Task
    By Steve in forum Excel General
    Replies: 1
    Last Post: 03-25-2006, 02:17 AM
  7. Start Macro Daily task
    By GoBucks in forum Excel General
    Replies: 1
    Last Post: 11-10-2005, 12:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1