I'm using this code on a cell in a separate tab:
='Sammich Ham'!$H$3
Each month I add a new column between G and H moving the previous months data from H to I making room for the new months data in column H. Adding this new column changes the formula from
='Sammich Ham'!$H$3 to ='Sammich Ham'!$I$3 How can I make it so it will always stay as H
Thanks in advance
='Sammich Ham'!$H$3
Each month I add a new column between G and H moving the previous months data from H to I making room for the new months data in column H. Adding this new column changes the formula from
='Sammich Ham'!$H$3 to ='Sammich Ham'!$I$3 How can I make it so it will always stay as H
Thanks in advance