Chrismx222
New Member
- Joined
- Apr 18, 2008
- Messages
- 14
Good Day.
I have a sheet where NOT all rows are the same. Some have gaps.
Where it reads PRICE I would like that to read the same
Where it reads a number I would like that to be raised by 10%
Right now I'm going through manually and copying and pasting rows 2621,2622,2623 wherever I need it, moving down the rows.
I can copy and paste, get into a rhythm (red square), but sometimes I have to skip over a random number of lines to continue my copy and paste. (blue square)
Currently in cell: N2638 I have the formula: =M2638
Currently in cell:N2640 I have the formula: =M2640*1.1
Is there a formula I can input into Column N so if column M reads PRICE it returns PRICE and if column M is a number it returns that number with a 10% increase?
Thank you in advance, this sheet is 30,000 lines long and I want some of my life left so I'm not copying and pasting my hours away
I have a sheet where NOT all rows are the same. Some have gaps.
Where it reads PRICE I would like that to read the same
Where it reads a number I would like that to be raised by 10%
Right now I'm going through manually and copying and pasting rows 2621,2622,2623 wherever I need it, moving down the rows.
I can copy and paste, get into a rhythm (red square), but sometimes I have to skip over a random number of lines to continue my copy and paste. (blue square)
Currently in cell: N2638 I have the formula: =M2638
Currently in cell:N2640 I have the formula: =M2640*1.1
Is there a formula I can input into Column N so if column M reads PRICE it returns PRICE and if column M is a number it returns that number with a 10% increase?
Thank you in advance, this sheet is 30,000 lines long and I want some of my life left so I'm not copying and pasting my hours away