Hi Folks!
I am grateful for the help I have received in my vlookup issue, but am now left with a new problem....
I have created the following sheet:
and want to copy it to a new page on the same sheet....without having to manually update every formula (that would take FOREVER).
I have been able to figure out how to copy an entire sheet to a new sheet, but i am trying to put the exact same data on the exact same sheet,
just a page lower. I have not found a simple way of doing this that won't take a very long time to manually adjust each formula to the new cell references.
Can anyone please make a suggestion? Thanks so much.
I am grateful for the help I have received in my vlookup issue, but am now left with a new problem....
I have created the following sheet:
FRP-In Progress.xlsx | |||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | |||
1 | |||||||||||||||||||||||||||||||||||||
2 | Oil Burner Repairs - Domestic (Beckett, Carlin, Wayne) | ||||||||||||||||||||||||||||||||||||
3 | |||||||||||||||||||||||||||||||||||||
4 | |||||||||||||||||||||||||||||||||||||
5 | Ask About Our Service Partner Savings Program Today! | ||||||||||||||||||||||||||||||||||||
6 | |||||||||||||||||||||||||||||||||||||
7 | |||||||||||||||||||||||||||||||||||||
8 | Partner Pricing | ||||||||||||||||||||||||||||||||||||
9 | Task ID | Description | Standard Price | Secondary Repair | Secondary Rep. Partner $ | ||||||||||||||||||||||||||||||||
10 | |||||||||||||||||||||||||||||||||||||
11 | # | OH101.60 | Replace Standard Burner Motor (Beckett) | 350 | 297 | 255 | 229 | ||||||||||||||||||||||||||||||
12 | # | OH102.60 | Replace Carlin Oil Burner Motor | 1147 | 975 | 1052 | 947 | ||||||||||||||||||||||||||||||
13 | # | OH103.45 | Replace R8184G Primary Control 15/30/45 Sec. Safety | 404 | 343 | 309 | 278 | ||||||||||||||||||||||||||||||
14 | # | OH104.30 | Replace Oil Burner Pump Coupling | 526 | 447 | 431 | 388 | ||||||||||||||||||||||||||||||
15 | # | OH105.120 | Convert Stack Relay To Primary Control | 836 | 711 | 741 | 667 | ||||||||||||||||||||||||||||||
16 | # | OH106.75 | Replace Primary Control w/ Cooling | 961 | 817 | 866 | 780 | ||||||||||||||||||||||||||||||
17 | # | OH107.60 | Replace Honeywell Fan Control Center | 1711 | 1455 | 1616 | 1455 | ||||||||||||||||||||||||||||||
18 | # | OH108.45 | Replace Honeywell L4064 Fan/Limit Control | 1931 | 1642 | 1836 | 1653 | ||||||||||||||||||||||||||||||
19 | # | OH109.15 | Replace Cad Cell (Eye-Only) | 271 | 231 | 176 | 159 | ||||||||||||||||||||||||||||||
20 | # | OH110.15 | Replace Cad Cell (Assembly) | 613 | 521 | 518 | 466 | ||||||||||||||||||||||||||||||
21 | # | OH111.15 | Replace Standard Fuel Filter Cartridge | 439 | 373 | 344 | 309 | ||||||||||||||||||||||||||||||
22 | # | OH112.15 | Replace Spin-On Fuel Filter Cartridge | 796 | 677 | 701 | 631 | ||||||||||||||||||||||||||||||
23 | # | OH113.45 | Replace Ignition Transformer - Standard | 339 | 288 | 244 | 220 | ||||||||||||||||||||||||||||||
24 | # | OH114.45 | Replace Ignition Transformer - Non-Standard | 580 | 493 | 485 | 437 | ||||||||||||||||||||||||||||||
25 | # | OH115.60 | Replace Single Stage Fuel Pump | 580 | 493 | 485 | 437 | ||||||||||||||||||||||||||||||
26 | # | OH116.60 | Replace 2 Stage Fuel Pump | 941 | 800 | 846 | 762 | ||||||||||||||||||||||||||||||
27 | # | OH117.40 | Clear Blocked Fuel Line w/ Nozzle, Filter, Strainer | 383 | 326 | 288 | 259 | ||||||||||||||||||||||||||||||
28 | # | OH118.90 | Replace Blast Tube/End Cone Combo up to 11" | 407 | 346 | 312 | 281 | ||||||||||||||||||||||||||||||
29 | # | OH119.50 | Replace End-Cone Only | 446 | 379 | 351 | 316 | ||||||||||||||||||||||||||||||
30 | # | OH120.30 | Replace Clogged Nozzle | 516 | 438 | 421 | 379 | ||||||||||||||||||||||||||||||
31 | # | OH121.45 | Replace Standard Tank Gauge | 1692 | 1438 | 1597 | 1437 | ||||||||||||||||||||||||||||||
32 | # | 76 | Replace Combo Tank Gauge/Vent Alarm | 272 | 232 | 177 | 160 | ||||||||||||||||||||||||||||||
33 | |||||||||||||||||||||||||||||||||||||
34 | |||||||||||||||||||||||||||||||||||||
35 | Never Pay Overtime Rates! | Know The Price BEFORE The Work Is Done! | FREE Extended Parts Warranty ! | ||||||||||||||||||||||||||||||||||
36 | |||||||||||||||||||||||||||||||||||||
Flat Rate Book |
Cell Formulas | ||
---|---|---|
Range | Formula | |
T11:T32 | T11 | =SUM((AL11*AM11)+(AO11*AP11)+AQ11)+AK11 |
X11,X13:X32 | X11 | =SUM(T11*AN11) |
AB11:AB32 | AB11 | =SUM(T11-AK11) |
AF11:AF32 | AF11 | =SUM(AB11*90%) |
X12 | X12 | =SUM(T12*AN11) |
A11:A32 | A11 | =AO11 |
and want to copy it to a new page on the same sheet....without having to manually update every formula (that would take FOREVER).
I have been able to figure out how to copy an entire sheet to a new sheet, but i am trying to put the exact same data on the exact same sheet,
just a page lower. I have not found a simple way of doing this that won't take a very long time to manually adjust each formula to the new cell references.
Can anyone please make a suggestion? Thanks so much.