I have an excel file with multiple worksheets that I work in each month to copy data. For the sake of simplicity, let us call them worksheets A and B. In worksheet A, there are two columns. One of these columns has SUM values for data entered into worksheet A. The other column in worksheet A has information that was pulled from worksheet B.
What I do is when I get to the next month, I create a copy of worksheet A and of worksheet B. Now, I would have worksheet A (2) and worksheet B (2). My problem is that now worksheet A (2) is pulling information from Worksheet B in the second column, however I want to make it pull information from worksheet B (2) in that column. I know that I could simply change the formula on one of the cells and then drag down from the corner of the cell to update all of the cells to similar formatting, the problem with that is that I end up losing a lot of my borders, lines, and colors in the cells that I use for appeareances sake.
I would like to know if there is a way if I make a copy of worksheet A, which pulls information from worksheet B, but then also make a copy of worksheet B, for the new worksheet A(2) to pull infomration from worksheet B(2) without all of the extra work.