• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I drag this formula up or down

Jack-P-Winner

Jack-P-Winner

Member
I am placing data on a different sheet using the = (to the other sheet) When I do that I get the example below. I know it has brackets around it and "I think" that means I can not copy and paste it like I would drag up or down formulas.

How can I take this formula and have the ability to drag it up to the next row on the new sheet and it copy the data from the other sheet? Id like to be able to drag it up or down. I want it to work how is appears in the Green below not the Red. This is for studying only so having the $ is not important for any kind of calculating or coding

='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!$AI$4
='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!$AI$4

='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!$AI$4
='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!$AJ$3

Again thank you for helping me with my project(s)!
 

Attachments

Jack-P-Winner said:
I am placing data on a different sheet using the = (to the other sheet) When I do that I get the example below. I know it has brackets around it and "I think" that means I can not copy and paste it like I would drag up or down formulas.

How can I take this formula and have the ability to drag it up to the next row on the new sheet and it copy the data from the other sheet? Id like to be able to drag it up or down. I want it to work how is appears in the Green below not the Red. This is for studying only so having the $ is not important for any kind of calculating or coding

='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!$AI$4
='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!$AI$4

='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!$AI$4
='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!$AJ$3

Again thank you for helping me with my project(s)!
Click to expand...
Hi,

Try it like this. Note the $ signs are gone from the end

='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!AI4
 
The purpose of the $ is to make the cell references not change when you copy/drag the formulas, so when you want the reference to change, just remove the $:

='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!AI4
='[2Step Numbers Book Stats (3,000+).xlsx]#1A-E-O'!AJ3
 
You must log in or register to reply here.
Back
Top