+ Reply to Thread
Results 1 to 4 of 4

Price Grid with Percentage Change

  1. #1
    Registered User
    Join Date
    03-12-2008
    Posts
    2

    Price Grid with Percentage Change

    I'm looking for some direction as to how to solve a problem I'm having.

    I'm trying to figure out the best way to create a solution inside of excel that would allow me to have a pricing grid and a percentage field somewhere that would not be printed. When I put a value into the percentage field, it would recalculate subtracting the percentage entered from all of the price grids. What would be the best way of going at this?

    Thank you.

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    send us a picture, please

  3. #3
    Registered User
    Join Date
    03-12-2008
    Posts
    2
    Quote Originally Posted by robert111
    send us a picture, please
    \1

  4. #4
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517
    The simplest option is probably to use the "hide" and "unhide" column feature.
    Right click on the tab at the top of the column and select hide.
    This column will not now be printed,
    unfortunately it is not shown at all and will have to be un-hidden in order to alter the value.
    (select the coulmns either side, rigght click, unhide).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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