Automatically open new sheet(Tab) and name it based on the specific value

R

reachdineshma

New Member
Joined
Jan 3, 2014
Messages
1
I have an excel with master sheet (TAB # 1) of employee's name (master sheet data range is B1:B100 ) . When i add a new employee name in another sheet (TAB # 2 data range is C1:C50), the macro should search in TAB # 1 (data range is C1:C50) , if the name entered in the TAB # 2 doesn't exists in the TAB # 1 (data range is C1:C50). it should create a new worksheet and name it with the name of new employee which is given in TAB # 2. Is this possible? can anyone help on this?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
You must log in or register to reply here.

Similar threads

B
  • Solved
vba code to give next Sunday date for pasted data
Replies
2
Views
246
bh24524
B
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
353
Insurance Dave
I
S
  • Question
Creating new sheets from template sheet plugging data into new sheets with particular criterias
Replies
1
Views
125
mumps
mumps
M
  • Solved
Conditional HYPERLINKS to worksheet tab based on a cell value
Replies
6
Views
394
smozgur
smozgur
T
  • Question
VBA code to export specific variably named tabs to new workbook?
Replies
2
Views
447
thebigejr
T

Forum statistics

Threads
1,215,963
Messages
6,127,964
Members
449,414
Latest member
sameri

Share this page

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