Results 1 to 4 of 4

Thread: Adding Macro to Template

  1. #1

    Adding Macro to Template



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    The attached is a scorecard that we use at our company to grade vendors. Right now as you see the file is setup to compare only two vendors in two business areas. However, I would like to make this template a bit more dynamic by adding the following macros:

    1) Macro to Add Vendors on Summary Tab: Is there a way to create a macro that will add a vendor (additional column) to both the Vendor % Fit and Weighted Vendor % Fit section on the Summary tab. Additionally, is it possibly to copy the formula logic and formatting logic for each cell from the prior column?

    2) Macro to Add Vendors on Detail Tab: Is there a way to create a macro that will add a vendor (additional column) within the Business Case sections (i.e., row 13 - 26 and 28 - 41 )to both the Raw Vendor Rating and Weighted Vendor Rating section on the Detail tab. Additionally, is it possibly to copy the formula logic and formatting logic for each cell from the prior column?

    3) Macro to Add Business Area/Use case section: Is there a way to create a macro that will add a new Business Area/Use case section (like row 13 - 26 or 28 - 41 ) under the last Business Area Case section (in this case after row 41). Additionally, is it possibly to copy the formula logic and formatting logic for each cell from the prior section? Also, when a new section is added on the Detail tab this will automatically add a line on the Summary Tab under the last line (in this case row 7). Once this line is added, the Total Business Area/Use case will be update to include the new line.
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Sorry, not totally sure I follow...

    You want to keep inserting columns for Vendor C, Vendor D, etc to the Detail sheet and have it also update on the Summary sheet?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Yes, when I insert Vendor C in the Detail tab, it should also insert a Vendor C column in the Summary tab, and carry over the formula from the cells in the prior column. I can record a video of what I am doing manually and how I would like to automate it, if that's easier?
    Last edited by PraveshG81; 2011-12-15 at 06:25 PM.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Sure, that would help!
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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