+ Reply to Thread
Results 1 to 2 of 2

Need to make a macro for weekly reporting task- never used a macro before

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    scotland
    MS-Off Ver
    2010
    Posts
    8

    Need to make a macro for weekly reporting task- never used a macro before

    Hi I'm looking to create a macro to save time in my busy schedule.

    My manager has handed me the task of creating a weekly report which can take a lot of time out of my day. I have been informed that a macro would be the best choice to reduce that time, but wouldn't even know were to start...

    Information

    I download 3 different spreadsheets, then use filters and lookup tables to determine how many quotes have been issued by a person. I do this for 3 different stages Initial quote, design, construction.

    After I have filtered and used pivot tables on all the data I take all the data and fill out a 'scorecard' with all the data I have found.


    I know this is very confusing, so I will attach a sample spreadsheet to this thread.

    The PROJECT No. is the most important number and is followed all the way through each spreadsheet. and the section in yellow in the scorecard is where all my information goes.

    I had to remove a lot of information for security reasons, but I have left the correct length of each sheet, if this helps.


    I don't even know if anyone can assist I have been looking at websites but don't find any of it helpful so just looking for a second pair of eyes to tell me if this is possible or even worth while... or how to do it lol

    Thanks

    Dave
    Attached Files Attached Files

  2. #2
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    Re: Need to make a macro for weekly reporting task- never used a macro before

    Hi Dave,

    Will go through your file and hopefully i will give the best help

+ 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. How to get summary/count of task on weekly basis
    By SJ73 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-16-2013, 06:20 AM
  2. [SOLVED] Make weekly Planner with macro or formula.
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2013, 11:24 PM
  3. Try to make a macro to do repeated task
    By JeffGajes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2012, 12:24 PM
  4. Weekly and Monthly Reporting
    By FourSeven in forum Excel General
    Replies: 0
    Last Post: 02-16-2011, 09:06 PM
  5. Date Calculation for Weekly Reporting
    By onthepitch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2010, 01:03 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