Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Using a field to let user +/- from values.

Alright, I tried posting this once, and I was completely lost. Let m
try to rexplain it. What I need, is on the spreadsheet, a field on th
bottom or anywhere really that a user could enter +.500 or -.275 o
really whatever they want. At that point, I would like excel to tak
that value and add it (or subtract it) to the values in the table.

Here is the sheet that I would like to be able to do this on. Whereve
it says 1.500 is obviously where excel would need to increase o
decrease the value. Obviously headings and real values have bee
omitted. Would appreciate any help you guys can give me. Thanks :

Attachment filename: dummy.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63226
--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 812
Default Using a field to let user +/- from values.

Excel offers this ability already. Put the amount you want to
add or subtract in a separate cell. Copy it. Select the range
of cells you want to increase or decrease. Then use the
menu Edit | Paste Special | Add (or Subtract).

HTH,
Merjet


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Security - customize field options based on user accou HBA Excel Discussion (Misc queries) 0 November 4th 08 06:50 PM
Error Message if user leaves a field blank GillianX Excel Worksheet Functions 1 October 14th 08 05:40 PM
User form to change manual field filter in pivot table bennyob Excel Discussion (Misc queries) 0 March 7th 07 01:00 PM
Get sum from field of values jright10 Excel Discussion (Misc queries) 1 August 10th 06 08:18 AM
CODE to select range based on User Input or Value of Input Field Sandi Gauthier Excel Programming 4 December 8th 03 03:22 PM


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"