I have a tariff document with pricing in it. It is 21 worksheets in the same
workbook. I want to increase columns D-I, rows 2 - 52 in each column, on
every single worksheet, by 20%.

Worksheet 1 is for Asia, cell D2 is minimum $290. Cell E2 is Asia-Europe at
$4.19.
Worksheet 2 is for USA, cell D2 is minimum @340. Cell E2 is US-Africa at
$6.32.

Can I get WRKSHT 1, cell D2 to change to $348, and E2 to $5.03, and get
WKRSHT 2, cell D2 to $408, E2 to $7.58 in one command?

How can I do this? Thanks.
--
Maddy

Increasing a cell value by 20% is the same as multiplying by 1.2. To
do this in one operation over a number of cells, enter the value 1.2
in a blank cell somewhere, and then <copy that cell. Highlight all
the cells that you want to increase and click on Edit | Paste Special
| Values (check) | Multiply (check) | OK then <Esc. Then you can
remove the 1.2 from the original cell.

Hope this helps.

Pete

On Jun 5, 10:02*pm, Madham wrote:
I have a tariff document with pricing in it. *It is 21 worksheets in the same
workbook. I want to increase columns D-I, rows 2 - 52 in each column, on
every single worksheet, by 20%.

Worksheet 1 is for Asia, cell D2 is minimum $290. *Cell E2 is Asia-Europe at
$4.19.
Worksheet 2 is for USA, cell D2 is minimum @340. *Cell E2 is US-Africa at
$6.32.

Can I get WRKSHT 1, cell D2 to change to $348, and E2 to $5.03, and get
WKRSHT 2, cell D2 to $408, E2 to $7.58 in one command?

How can I do this? *Thanks.
--
Maddy