Dec 11 2019 09:47 AM
I know that if you copy a formula and paste it to multiple cells that it will automatically change the cell number (change C11 to C12, C13, etc) but when I copy a formula containing data from cells from a different spreadsheet it keeps the cell number the same for all the cells I copy to. Is there a way to get it to do the former without me having to manually change the cell number for every one?
Dec 11 2019 11:45 AM - edited Dec 11 2019 11:46 AM
SolutionIf your formula looks like this:
=[Book2]Sheet1!$C$13
..... make sure you remove the dollar signs before you copy it down. Then, the formula will automatically change as you want it to.
Dec 11 2019 12:57 PM
@Riny_van_EekelenThank you so much! That will save me a ton of time.
Dec 11 2019 11:45 AM - edited Dec 11 2019 11:46 AM
SolutionIf your formula looks like this:
=[Book2]Sheet1!$C$13
..... make sure you remove the dollar signs before you copy it down. Then, the formula will automatically change as you want it to.