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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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
193
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
263
Insurance Dave
I
S
  • Question
Creating new sheets from template sheet plugging data into new sheets with particular criterias
Replies
1
Views
40
mumps
mumps
M
  • Solved
Conditional HYPERLINKS to worksheet tab based on a cell value
Replies
6
Views
363
smozgur
smozgur
T
  • Question
VBA code to export specific variably named tabs to new workbook?
Replies
2
Views
422
thebigejr
T

Forum statistics

Threads
1,215,147
Messages
6,123,295
Members
449,095
Latest member
Chestertim

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