Kyle Johnson2 said:Have you tried using an absolute cell reference like = Sheet3!$C$3
?
I did, and the letter still changes.
Home ›
jadedrifter16 › Posts
Posts by jadedrifter16
4 posts shown.
I did, and the letter still changes.
Quick question about Excel
I need a formula that pulls data from one specific cell on another sheet. I know how to use something like = Sheet3!C3 to get the job done, but there’s a catch: if I insert a new column, everything shifts. Suddenly, what was in column C moves to column D, and my formula automatically updates to = Sheet3!D3.
Is there a way to lock this down so it always grabs C3, regardless of whether someone decides to shove a new column in between?
I need a formula that pulls data from one specific cell on another sheet. I know how to use something like = Sheet3!C3 to get the job done, but there’s a catch: if I insert a new column, everything shifts. Suddenly, what was in column C moves to column D, and my formula automatically updates to = Sheet3!D3.
Is there a way to lock this down so it always grabs C3, regardless of whether someone decides to shove a new column in between?
Where can I find, buy, or... "borrow" these? (Mega-thread) :D
in Miscellaneous ·
A friend of mine just got a promotion, and I’m looking to pick up a plush teddy bear wearing a graduation cap and holding a diploma. Does anyone know where I can track one down?
Where can I find, buy, or... "borrow" these? (Mega-thread) :D
in Miscellaneous ·
Does anyone know where I can pick up a teddy bear wearing a graduation cap in the States?