Forum Discussion
Change Cell Reference but Only Row Changes
Hello Contributors! I am having a hard time dealing with my file I hope someone can lend me a hand. I need to do cell referencing but the column should remain the same while there should be a +1 ...
Hello! Thanks for reaching out! What I want to do, if possible, is if I can make K1='INPUT DATA'!A2 into S1='INPUT DATA'!A3 by just dragging the selected cells to the right to create multiple copies. Is there any possible way I can do this?