Advertisement

07.18.2008 at 07:14AM PDT, ID: 23576906
[x]
Attachment Details

Excel - Automatically extract a name form a list and place into a new worksheet

Asked by Carlandrewlewis in Office & Productivity Software, Microsoft Excel Spreadsheet Software, Spreadsheet Software

Tags: excel automatic worksheets from list

I have a list of employees and everytime i enter a new name it automatically creates a new worksheet as there name. What i would like to do is when i add a name to my list and it creates a new worksheet for the employees name to appear in the merged F2 cell at the top of the page.Start Free Trial
Attachments:
 
Daily-Exposure-Records.xls (109 KB) (File Type Details) 
Employee list and template
 
[+][-]07.18.2008 at 07:19AM PDT, ID: 22036025

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Office & Productivity Software, Microsoft Excel Spreadsheet Software, Spreadsheet Software
Tags: excel automatic worksheets from list
Sign Up Now!
Solution Provided By: saurabh726
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.18.2008 at 07:25AM PDT, ID: 22036102

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 07:30AM PDT, ID: 22036165

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906