Solved How to rename copied cells and update

September 23, 2015 at 07:41:31
Specs: Windows 7
Hello,

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.

Thanks!


See More: How to rename copied cells and update

Report •


#1
September 23, 2015 at 07:53:46
✔ Best Answer
I created 2 work sheets:

A   B

In A!C1 I entered this formula:

=B!A1

That should fulfill this requirement: "The other column in worksheet A has information that was pulled from worksheet B."

I then Selected the tabs for A and B (together), right-clicked and chose Move or Copy...
I checked the Create a copy box.

I ended up with these sheets.

A   B   A (2)  B (2)

In A (2)!C1 I see this formula:

='B (2)'!A1

Is that not what you get?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 23, 2015 at 07:54:38
I'm not sure how to delete this post, but I found a solution in creating a template using the worksheet A and worksheet B and then just inserting the templates and renaming them each month.

Solved my own issue, admins please delete my post if possible! Thank you!


Report •

#3
September 23, 2015 at 08:00:12
Hi Derby,

Thank you! Your solution is even simpler than mine. It makes a lot of sense to be able to copy two worksheets at one but unforunately Excel doesn't make it very obvious that you have in fact copied two cells. I tried to go to move or copy and push control in the popup window and highlight two cells but that would not work, I didn't realize that selecting multiple worksheets from the bottom of excel using control would have an effect, as even then you could only highlight one worksheet name at a time in the popup. It does work, though, even if it doesn't seem like it will.

Thank you!


Report •

Related Solutions

#4
Report •

Ask Question