BetaONE will rise again!


Reply
  #1  
Old 10th Nov 06, 09:58 PM
PCTech PCTech is offline
Senior Member
 
Join Date: May 2003
Location: USA
Posts: 362
PCTech is an unknown quantity at this point
Send a message via AIM to PCTech
excel - adding XX% to a range of cells
Alright, I'm trying to make custom price lists, I have everything in a few different spreadsheets (about 15000 different product sku's, that my company sales). I know that I would have to do this to each spreadsheet but...


I know how to put a button an excel spreadsheet, I want to enter a percentage into lets say cell A1 and then click a button to ADD the additional percentage to the cost in all of the cells in a range say from cell b2 through b5000

is there a way to do this, I really dont want to have to start all of these spread sheets all over!

is anyone as confused as I just made myself ??
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:38 PM.


Design by Vjacheslav Trushkin for phpBBStyles.com.
Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.