annual increases in price lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have an excel price list which is increased by percentages using formulae
and creating a new sheet each year within the same work book. Can we turn
the latest work sheet containing the formulae and linked through all the
previous sheets into an original that can be used as the next starting point
without re-typing the formulae or original prices ?

Any one have any experience
 
If you're asking to simply get what's in the current sheet from formulae into
values, select the entire sheet, copy (ctrl+c) and, from the menu bar Edit >
Paste Special, select Values and click OK. I'd first copy the sheet
(right-click on the worksheet tab, select Move or Copy, check Copy and click
OK) to be safe.
--Bruce
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Price List overall price increase 4
How to increase all prices in price sheet by certain percent? 6
Need to increase price by % and rounding up and down 5
Excel Price List 1
Increasing a price by % 2
how do i increase the value of numbers in a column by a percentage 5
Percentage Increase 13
price increase to always end in 9, i.e. 1.99 1

Back
Top