Client list price update

T

tljeffrey21

Hi all, can someone please tell me if you can up data a work page by a
certian amount (eg 10%) automatically. Basically I have just done a
list of all my customers and how much they pay foe various items. What
I want to be able to do is update to price when a price rise may occur
without have to manually changing each item. I done the sheet in MS
Access and have imported it to excel for more staff you use and view.
Can anyone help?? Thankyou
 
P

paul

depending on howyou actually have your prices,normally in a column,in the
column next to the first entry (say C1) type = b1*1.1 and copy down,then copy
that column and go paste special paste as value into the column the prices
were in,then delete column c....
 
T

tljeffrey21

Thanks, but that not what I was getting at.... imagine this across row 1
are the titles of the columns (eg. Customer Name, Code, Product1 price,
product 2 price etc) So I have 60 clients down column 1 then there
codes in column 2, there price for buyin item one, there price for
buyin item 2 etc. See attchment for what I mean. Now, is there a way I
can update prices by a certain percent with out having to do it
manually? Can I just select the cells and tell them to update 10 %?

Thanks for your help


+-------------------------------------------------------------------+
|Filename: Customers Prices 1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4196 |
+-------------------------------------------------------------------+
 
T

tljeffrey21

Cheers Roger, exactly what I was looking for. Any idea on how to do i
with text in the cell as well (as in the cell I want to update)
 
R

Roger Govier

Hi

Perhaps the following might work, depending upon how the words and text
are arranged. Without seeing the data, I can't tell (you cannot post
attachments to these NG's)

Copy the column of data to another part of the sheet, with blank columns
to the right of it.
Data>Text to columns> to split the words and numerics.
Apply the percentage update to the values (as described)
in another cell, concatenate back the words and uplifted values.
Copy the range of the new concatenated data> Paste Special>Values back
over your original column of data.

--
Regards

Roger Govier


"tljeffrey21" <[email protected]>
wrote in message
news:[email protected]...
 
Top