+ Reply to Thread
Results 1 to 12 of 12

Added percentage markup and need help add to grand total...too many formulas!

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    84

    Added percentage markup and need help add to grand total...too many formulas!

    Solved. thank you!
    Attached Files Attached Files
    Last edited by trfountain22; 05-15-2015 at 01:06 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,858

    Re: Added percentage markup and need help add to grand total...too many formulas!

    A lot of formulae...

    The first thing that caught my eye was EQT row 48, and the #N/A errors.

    F48 says: =IF(ST=0,0,(VLOOKUP(ST,UseTax,2,FALSE)*(RawMatl-Exempt)/1.08))

    If the state is zero, enter 0, otherwis look up the state against a table (UseTax) and return the value correspnding to the state from column 2 blah blah blah.

    one problem. The Table UseTax doesn't exist!!. The Named Range is there (CTRL F3), it refers to a sheet called Codes.... but there's no sheet called codes, so the lookup breaks down. Find it and your problem might not be solved, but at least you won't be looking at error messages and will (maybe) be able to figure out where to go next.
    Glenn



  3. #3
    Registered User
    Join Date
    10-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    84

    Re: Added percentage markup and need help add to grand total...too many formulas!

    Ok. Thank you so much. I will see if I can figure something out. I really appreciate it.

    In the meantime....I opened the file and like always, it asked me to enable macros. I did, no problems. Then it was so weird...I closed the file and when I reopened it, I no longer get promoted to enable macros and they will not run. I checked the macro settings....It's set to disable with notification. I closed everything out....reopened...still the same thing. Any idea why this would happen or how to fix it?

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,858

    Re: Added percentage markup and need help add to grand total...too many formulas!

    I didn't add/alter any macros. They were there on what you sent me. Normally when you enable macros on a file (I recall) it normally doesn't ask you again. They just run....

    Not sure if that helps - but if you just take the text from my ealier post and work off your own sheet (not the one you posted on the www) you should be OK.

  5. #5
    Registered User
    Join Date
    10-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    84

    Re: Added percentage markup and need help add to grand total...too many formulas!

    Oh...I didn't think you altered anything....I was working on the file from my computer, not the one I uploaded. I'm not sure why it's doing it. Not going to worry about it. Trying to fix what you told me...unsuccessfully! Let me ask you this....what if I can't find the sheet "codes." Then what would I do?

  6. #6
    Registered User
    Join Date
    10-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    84

    Re: Added percentage markup and need help add to grand total...too many formulas!

    In the developer tab, in the drop down list there is a sheet that says codes.....would that be it? How do I access it?

  7. #7
    Registered User
    Join Date
    10-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    84

    Re: Added percentage markup and need help add to grand total...too many formulas!

    Can you look at it now? I found the sheets. Have no clue what to do next?

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,858

    Re: Added percentage markup and need help add to grand total...too many formulas!

    Yep. That's it. Stlill there, but just "very hidden".

    ALT 11 to enter VB Editor
    Click on CODES
    hit F4
    go to bottom of properties box
    reset to visible
    Voila....

  9. #9
    Registered User
    Join Date
    10-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    84

    Re: Added percentage markup and need help add to grand total...too many formulas!

    Thank you so much! You don't know how much I appreciate it. I want to learn more...does anyone on this forum teach...lol...like walk me through everything in this file??? As a paid service...do people do that??? This has been handed over to me and I am a basic user. I'm learning as I go that's for sure! I appreciate your help so very much! Is there a way I can acknowledge you for helping me? I'm new to the forum thing!

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,858

    Re: Added percentage markup and need help add to grand total...too many formulas!

    No. We do this for fun... There is a Commrcial Servics forum where you can (in return for real money) get the undivided atention of the real experts (I'm nnot in that select band..).

    For me - just hit the Add Reputation button when I've sorted you out - or gone as far as I can... (which I suspect may be right now!! - We'll see).

  11. #11
    Registered User
    Join Date
    10-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    84

    Thumbs up Re: Added percentage markup and need help add to grand total...too many formulas!

    I'm sorry....Where is the reputation button? I don't see one!

  12. #12
    Registered User
    Join Date
    10-03-2014
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    84

    Re: Added percentage markup and need help add to grand total...too many formulas!

    Never mind. Found it!

+ 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. Replies: 9
    Last Post: 03-18-2015, 07:16 AM
  2. Pivot showing percentage in Grand total grouped by first column
    By matpj in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-16-2014, 09:47 AM
  3. [SOLVED] Pivot Table Grand Total Percentage Error
    By rosehill in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2013, 10:01 AM
  4. Pivot table - calculating percentage on grand total
    By sri023 in forum Excel General
    Replies: 3
    Last Post: 07-13-2012, 02:42 PM
  5. Pivot Table Percentage of Grand Total Column
    By Jacob in forum Excel General
    Replies: 6
    Last Post: 03-08-2006, 01:10 AM

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