Changing Tab Focus

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I have three tabs in a worksheet; Their names are

Current, Current(2) and Data-Tables.

Current(2) is an exact copy of Current. The Data-Tables sheet gets
it's information from the Current tab.

I use Current(2) to make changes and improvements. After a while I
decide I want to use Current(2) in stead of Current.

How do I get the Data-Tables sheet to recognize Current(2) instead of
Current?

I tried changing the names back and forth, but that doesn't work.

If I delete the Current tab and then rename Current(2) to Current the
Data-Tables sheet is full of Reference errors.

Must be an easy way.
 
In the Data-Tables sheet, highlight all the cells with formulae in
them and CTRL-H (Find & Replace) as follows:

Find What: Current!
Replace with: Current(2)!
Click Replace All

Then you could delete the Current sheet, and maybe rename Current(2)
to Current.

Hope this helps.

Pete
 
Worked great, thanks.

In the Data-Tables sheet, highlight all the cells with formulae in
them and CTRL-H (Find & Replace) as follows:

Find What: Current!
Replace with: Current(2)!
Click Replace All

Then you could delete the Current sheet, and maybe rename Current(2)
to Current.

Hope this helps.

Pete
Click to expand...
 
Back
Top