Help! Copying Formula to another Cell then Row will auto change

H

hunter204

New Member
Joined
Aug 22, 2011
Messages
12
Good Day To all,
Untitled-2.jpg
Formula Use:In Cell B4= 'Data Summary New format'!$Y$8What I want to do is if I copied the formula in B4 and paste it in F4 the formula in F4 should be like this 'Data Summary New format'!$Y$9 (it's obviously change to 9 and it added +1 while the column doesn't change.P.S. The values were linked to other sheet.Is this possible to do?
 
Sort by date Sort by votes
Good Day To all,

Untitled-2.jpg


Formula Use:In Cell B4= 'Data Summary New format'!$Y$8


What I want to do is if I copied the formula in B4 and paste it in F4 the formula in F4 should be like this 'Data Summary New format'!$Y$9 (it's obviously change to 9 and it added +1 while the column doesn't change.

P.S. The values were linked to other sheet.Is this possible to do?
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Copy formulas from one sheet to another while keeping it linked to the Original
Replies
1
Views
408
Excel2021
E
A
  • Question Question
Copy Cell to a row with corresponding number
Replies
0
Views
67
anyrandomtech
A
H
  • Question Question
VBA Loop to Copy Cell Value from worksheets to new worksheet with Worksheet Name
Replies
4
Views
170
saboh12617
S
D
  • Question Question
Vba to create a new excel file and convert all cell formulas to text
Replies
3
Views
148
Candyman8019
C
J
  • Question Question
Copy Formula Contents Only
Replies
1
Views
93
Artik
Artik

Share this page

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