I have a report that provides a snapshot of information from the prior day, then I click a button (VBA code) upon completion and it takes data stored in certain cells on the report tab and moves it to another tab where its position is re-organized so I can track the data on a trend line.
On the Trend tab if I highlight column C, for example, and insert a new column it pushes all of the data to the right but the cell references in my VBA code don't change. So when I need to re-organize the trend tab to incorporate more/different data it's becoming more laborious to go back to the VBA code and update all of the cell references.
Is it possible to reference the cells in my VBA code, in a way that they will change in concert with the data in the trend tab if I move things around?