updating data (dividing)

**Bluejay12** · 11-10-2012, 05:23 PM

I have a 30 sheet file and I need to divide the data by 24...

data which need to be updated are in the same columns (E,H,K etc...) in every sheet

there is no formula it these cells just a number

Thanks for help

**Armando Montes** · 11-10-2012, 05:39 PM

Group all sheets
Enter 20 in any blank cell and copy it
Select the range to be divided
Paste Special
Divide
Delete the 20
Ungroup the sheets
http://www.dummies.com/how-to/conten...xcel-2010.html

**Bluejay12** · 11-10-2012, 06:20 PM

thanks a lot problem solved

just one more question is it possible to use something from special paste for every copy and paste? (I need only values)

thanks

**Armando Montes** · 11-10-2012, 06:32 PM

Copy the range, paste special, values.
http://www.symplebyte.com/microsoft_...ial_excel.html

**Bluejay12** · 11-10-2012, 06:38 PM

I meant if it possible to set it to values for the whole worksheet and keep it that way for multiple copy/paste... I will need to do countless copy/paste and I need to use values in every one.