I Feel Stupid Asking this question. (Copy an entire page of a sheet onto the SAME sheet, without having to manually update forumlas)

Jingles3X

New Member
Joined
Oct 20, 2021
Messages
34
Office Version
  1. 2013
Platform
  1. Windows
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:
FRP-In Progress.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
2Oil Burner Repairs - Domestic (Beckett, Carlin, Wayne)
3
4
5Ask About Our Service Partner Savings Program Today!
6
7
8Partner Pricing
9Task IDDescriptionStandard PriceSecondary RepairSecondary Rep. Partner $
10
11#OH101.60Replace Standard Burner Motor (Beckett)350297255229
12#OH102.60Replace Carlin Oil Burner Motor11479751052947
13#OH103.45Replace R8184G Primary Control 15/30/45 Sec. Safety404343309278
14#OH104.30Replace Oil Burner Pump Coupling526447431388
15#OH105.120Convert Stack Relay To Primary Control836711741667
16#OH106.75Replace Primary Control w/ Cooling961817866780
17#OH107.60Replace Honeywell Fan Control Center1711145516161455
18#OH108.45Replace Honeywell L4064 Fan/Limit Control1931164218361653
19#OH109.15Replace Cad Cell (Eye-Only)271231176159
20#OH110.15Replace Cad Cell (Assembly)613521518466
21#OH111.15Replace Standard Fuel Filter Cartridge439373344309
22#OH112.15Replace Spin-On Fuel Filter Cartridge796677701631
23#OH113.45Replace Ignition Transformer - Standard339288244220
24#OH114.45Replace Ignition Transformer - Non-Standard580493485437
25#OH115.60Replace Single Stage Fuel Pump580493485437
26#OH116.60Replace 2 Stage Fuel Pump941800846762
27#OH117.40Clear Blocked Fuel Line w/ Nozzle, Filter, Strainer383326288259
28#OH118.90Replace Blast Tube/End Cone Combo up to 11"407346312281
29#OH119.50Replace End-Cone Only446379351316
30#OH120.30Replace Clogged Nozzle516438421379
31#OH121.45Replace Standard Tank Gauge1692143815971437
32#76Replace Combo Tank Gauge/Vent Alarm272232177160
33
34
35Never Pay Overtime Rates!Know The Price BEFORE The Work Is Done!FREE Extended Parts Warranty !
36
Flat Rate Book
Cell Formulas
RangeFormula
T11:T32T11=SUM((AL11*AM11)+(AO11*AP11)+AQ11)+AK11
X11,X13:X32X11=SUM(T11*AN11)
AB11:AB32AB11=SUM(T11-AK11)
AF11:AF32AF11=SUM(AB11*90%)
X12X12=SUM(T12*AN11)
A11:A32A11=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.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
I haven't actually used your provided data, but that seems like a no-brainer. Those formulas are not even anchored, and even if they were, copying the cells down would work just fine. I'm not sure why you can't copy those without issues.
 
Upvote 0
Seems simple to me.....Highlight rows 1 to 39>>Copy>>select the new location you want paste in>>>Paste
 
Upvote 0
I haven't actually used your provided data, but that seems like a no-brainer. Those formulas are not even anchored, and even if they were, copying the cells down would work just fine. I'm not sure why you can't copy those without issues.
I thought the same... until i tried it. The formulas copied, but exvery cell with a formula resulted in a #REF in the pasted cells.
 
Upvote 0
#REF error is the message Excel displays when a formula references a cell that no longer exists, usually caused by deleting cells that a formula is referring to.
SO, did you copy rows as I mentioned OR did you select the range of data and move it left or right before pasting ??
 
Upvote 0
@Jingles3X Can you provide a larger portion of your data?

Your formulas indicate values from the AQ column, but the data you provided only goes to the AI column.
 
Upvote 0

Forum statistics

Threads
1,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top