Help updating tab reference automatically or with macro

TS656577

New Member
Joined
Apr 7, 2015
Messages
10
Office Version
  1. 365
Platform
  1. Windows
I currently have my excel sheet to copy a tab, and generate new ones/renaming them based off of cells. Referencing picture "Capture1a", a user inputs whatever word into each cells. A macro then copies another tab, and renames it based off of those aforementioned cells. The text from cells of "capture1a" is copied to cells shown in "capture1b". The cells E8-E12 reference the new, named tabs, or that's how it worked before. Is there a way to update the reference in cells E8-E12 based on the newly named tabs? There could be as many as 20 new tabs but i'm hoping if one thing works, i'm smart enough to expand upon it for other cells.

Is this possible by creating a button or something that once all of the new tabs are generated, it'll update the tab reference in E8-E12?

Previously, all the cells under Vendor (E8-E12) were prenamed but it was very limited to the user if they wanted to rename something. My idea with doing it this way is that a user can generate tabs for whatever they want, but the workbook in general will still work the same way. I think it'll be a lot more flexible. Any help is appreciated!
 

Attachments

  • Capture1a.PNG
    Capture1a.PNG
    1.8 KB · Views: 19
  • Capture1b.PNG
    Capture1b.PNG
    12.4 KB · Views: 26

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Try...

VBA Code:
Sub ShtNotExist()
    Dim i As Long
    Application.ScreenUpdating = False
    
    With Sheets("Project Scope")
    
        For i = 8 To .Cells(Rows.Count, "A").End(xlUp).Row
            If Not Evaluate("isref('" & .Cells(i, "A").Value & "'!A1)") Then _
                        Sheets.Add(After:=Sheets(Sheets.Count)).Name = .Cells(i, "A").Value
        Next
        
        .Select
    End With
End Sub
 
Upvote 0
Oops, on a reread I think my code is doing the reverse of what you want
 
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,184
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top