Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to update price increases on multiple sheets
I have an excel file with multiple tabs for each category of my price book. I
need to set this up with an easy way to be able to globally update all these prices with a percentage increase without going to each page. The structure of the first page is a contents page and the rest are the same structure. The first column of numbers is the actual price, the second column is the price marked up a certain percentage and a third column marked up another percentage. Is there a formula that will quick update all tabs, not changing the first column of prices, but updating the second column by one percentage and the third column by a different percentage |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to update price increases on multiple sheets
I may be missing something here - it's happened before - but why not
just use cell formulas? That is, have a cell on your main worksheet with the percentage increase you want use everywhere, then use cell formulas on the other sheets which increase the prices on that particular sheet based on the value in this cell? (Or two cells, if you have two sets of percentages you're dealing with). / Tyla / On Mar 1, 7:41 am, Diane wrote: I have an excel file with multiple tabs for each category of my price book. I need to set this up with an easy way to be able to globally update all these prices with a percentage increase without going to each page. The structure of the first page is a contents page and the rest are the same structure. The first column of numbers is the actual price, the second column is the price marked up a certain percentage and a third column marked up another percentage. Is there a formula that will quick update all tabs, not changing the first column of prices, but updating the second column by one percentage and the third column by a different percentage |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to update price increases on multiple sheets
I could do that, I was looking for a quick way without going to each sheet
since there are so many sheets in this workbook already set up. " wrote: I may be missing something here - it's happened before - but why not just use cell formulas? That is, have a cell on your main worksheet with the percentage increase you want use everywhere, then use cell formulas on the other sheets which increase the prices on that particular sheet based on the value in this cell? (Or two cells, if you have two sets of percentages you're dealing with). / Tyla / On Mar 1, 7:41 am, Diane wrote: I have an excel file with multiple tabs for each category of my price book. I need to set this up with an easy way to be able to globally update all these prices with a percentage increase without going to each page. The structure of the first page is a contents page and the rest are the same structure. The first column of numbers is the actual price, the second column is the price marked up a certain percentage and a third column marked up another percentage. Is there a formula that will quick update all tabs, not changing the first column of prices, but updating the second column by one percentage and the third column by a different percentage |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to update price increases on multiple sheets
Post the formulas for columns 2 and 3 please. Are these formulas filled to
the bottom of data in column 1? Are all sheets identical and need updating? Regards, Alan "Diane" wrote in message ... I have an excel file with multiple tabs for each category of my price book. I need to set this up with an easy way to be able to globally update all these prices with a percentage increase without going to each page. The structure of the first page is a contents page and the rest are the same structure. The first column of numbers is the actual price, the second column is the price marked up a certain percentage and a third column marked up another percentage. Is there a formula that will quick update all tabs, not changing the first column of prices, but updating the second column by one percentage and the third column by a different percentage |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to update price increases on multiple sheets
Column 1 just shows the price for a part, column 2 shows "=C8/$D$3 with D#
having a value of 0.7 for the markup, column 3 shows "=C8/$E$3 the value in E3 is 0.6 I know this will markup the whole page by changing the value at the top. Each sheet is the same, no totals. Can all sheets be done from some formula on the main page without putting a formula in each page? "Alan" wrote: Post the formulas for columns 2 and 3 please. Are these formulas filled to the bottom of data in column 1? Are all sheets identical and need updating? Regards, Alan "Diane" wrote in message ... I have an excel file with multiple tabs for each category of my price book. I need to set this up with an easy way to be able to globally update all these prices with a percentage increase without going to each page. The structure of the first page is a contents page and the rest are the same structure. The first column of numbers is the actual price, the second column is the price marked up a certain percentage and a third column marked up another percentage. Is there a formula that will quick update all tabs, not changing the first column of prices, but updating the second column by one percentage and the third column by a different percentage |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to update price increases on multiple sheets
Diane,
On Mar 1, 1:21 pm, Diane wrote: Column 1 just shows the price for a part, column 2 shows "=C8/$D$3 with D# having a value of 0.7 for the markup, column 3 shows "=C8/$E$3 the value in E3 is 0.6 I know this will markup the whole page by changing the value at the top. Each sheet is the same, no totals. Can all sheets be done from some formula on the main page without putting a formula in each page? "Alan" wrote: Post the formulas for columns 2 and 3 please. Are these formulas filled to the bottom of data in column 1? Are all sheets identical and need updating? Regards, Alan "Diane" wrote in message ... I have anexcelfile with multiple tabs for each category of my price book. I need to set this up with an easy way to be able to globally update all these prices with a percentage increase without going to each page. The structure of the first page is a contents page and the rest are the same structure. The first column of numbers is the actual price, the second column is the price marked up a certain percentage and a third column marked up another percentage. Is there a formula that will quick update all tabs, not changing the first column of prices, but updating the second column by one percentage and the third column by a different percentage |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to update price increases on multiple sheets
Ignore the past post (obviously!)
There are a couple ways you could go here. You could do a one-time macro to change all the formulas, but if you're uncomfortable with macros. try this: - Create (or simple decide) on a master worksheet which will store the two %s you want to use throughout the other worksheets. - Highlight all the worksheets which have the prices you want to update based on these precentages. - Go to cell D3 (and later E3) and change (or assert) the formula there to point to the chosen cell on the master worksheet. Then hit "Enter" What you should end up with is a formula on each of the highlighted sheets which looks something like "=Sheet1!A1" Given that each of the worksheets has formulas which already reference D3 (or E3), the end result should be you'll only have to change the % in the 'master' worksheet and it will propogate through all the other worksheets. / Tyla / On Mar 1, 1:21 pm, Diane wrote: Column 1 just shows the price for a part, column 2 shows "=C8/$D$3 with D# having a value of 0.7 for the markup, column 3 shows "=C8/$E$3 the value in E3 is 0.6 I know this will markup the whole page by changing the value at the top. Each sheet is the same, no totals. Can all sheets be done from some formula on the main page without putting a formula in each page? "Alan" wrote: Post the formulas for columns 2 and 3 please. Are these formulas filled to the bottom of data in column 1? Are all sheets identical and need updating? Regards, Alan "Diane" wrote in message ... I have anexcelfile with multiple tabs for each category of my price book. I need to set this up with an easy way to be able to globally update all these prices with a percentage increase without going to each page. The structure of the first page is a contents page and the rest are the same structure. The first column of numbers is the actual price, the second column is the price marked up a certain percentage and a third column marked up another percentage. Is there a formula that will quick update all tabs, not changing the first column of prices, but updating the second column by one percentage and the third column by a different percentage |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate a specific formula for price increases? | Excel Worksheet Functions | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
comparing two sheet of data -- cost price increases | Excel Worksheet Functions | |||
How can I update pricebook increases in different percentages | Excel Worksheet Functions | |||
annual increases in price lists | Excel Discussion (Misc queries) |