+ Reply to Thread
Results 1 to 1 of 1

VBA/Macro to Automatically Update, Copy, & Sort information from Sheet 1 to Sheet 2

  1. #1
    Registered User
    Join Date
    08-21-2017
    Location
    Boston, Ma
    MS-Off Ver
    Office 365
    Posts
    1

    VBA/Macro to Automatically Update, Copy, & Sort information from Sheet 1 to Sheet 2

    Morning all,

    I am fairly new to the macro/VBA world and need some help driving this project home. I am working on an employee attendance log that tracks hours used and hours remaining based off a static 40 hours. I have been able to record a macro that does what I need but its not very user friendly. I have also been able to find ways to code a few of the steps below but I can not seem to make them work together.

    I have attached a sample of the recorded macro I am currently using. It has sufficed to this point but I am looking to refine the process. I understand that there are ways to do this manually, which I was doing previously, but this format is now being spread out company wide and I have been assigned to refine it. I need to keep it as "simple-stupid" as possible for the user.

    What I am looking to do:
    1- Copy information from Sheet 1 to Sheet 2.
    2- Sheet 2 will then sort information by name alphabetically
    3- Sheet 2 will include totals at each change in name
    4- Sheet 2 will automatically update with each new entry on Sheet 1
    5- Lock coding so unauthorized changes can not be made without stopping the macro/code from working

    Any help would be greatly appreciated.
    Thanks in advance.

    - E
    Attached Files Attached Files

+ 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. [SOLVED] Sort data from one sheet to others. Update automatically
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2016, 04:07 PM
  2. Automatically Sort data in three columns when I update column E (Protected Sheet)
    By pwhittak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2016, 08:12 AM
  3. [SOLVED] Macro Copy and Paste from one sheet to another sheet only where there is information
    By Elmarie_Potgieter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2013, 03:13 AM
  4. Replies: 7
    Last Post: 12-03-2012, 03:10 AM
  5. [SOLVED] Macro to copy row information from sheet to sheet won't work
    By beth.randall in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2012, 01:31 PM
  6. Macro to Look for Sheet, create if none, sort items from master & copy to new sheet.
    By ali.whitaker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2012, 12:58 PM
  7. Replies: 0
    Last Post: 01-14-2011, 12:01 PM

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