Projections
I have a list of products with a sales projection for each product, I want to adjust the projections by a fixed percentage, either upwards or downwards for the entire list?
RE: Projections
Answer to post: This could be achieved by following these steps:
1. Enter the factor you want used to increase or decrease the numbers in your list in a cell. (eg: If you wanted to decrease the numbers in your list by 20% enter 80%, to increase your projections enter 120% to raise the value by 20%).
2. With your increase/decrease factor as the active cell, click the Toolbar Copy button (or choose Edit, Copy - CTRL+C)
3. Highlight the numbers in your list that you wish to manipulate, and choose Edit, Paste Special.
4. In the Paste section select Values; in the Operation section, select Multiply, Click OK.
The numbers in your list will be increased or decreased by the amount you specified.
