theanchorman
New Member
- Joined
- Aug 24, 2012
- Messages
- 31
I have a spreadsheet where multiple cells are pulling data from one column using cell references based on the month I need. Currently i use the find and replace option to change the column if need to point to the a different month. Is there a way i can write formulas to where I can point to one cell that has the column stated and if I change the one cell it changes all the cell references to pull from another column?
Ex. Cell B30 is data from February month and currently I use the find and replace function to change the column from B to C if i need the data to pull from a different month March. Is there a way I can link the cell references to one cell and i can change that one cell that says "B" and change to "C" so all formulas would update to pull from column C30?
Ex. Cell B30 is data from February month and currently I use the find and replace function to change the column from B to C if i need the data to pull from a different month March. Is there a way I can link the cell references to one cell and i can change that one cell that says "B" and change to "C" so all formulas would update to pull from column C30?