Perhaps

Sub addasheet()
Worksheets.Add
ActiveSheet.Name = Worksheets("Sheet1").Range("A1").Value
End Sub

Mike

"eva" wrote:

How can I create a macro wherein the actions include adding a new worksheet
and naming the worksheet based on a field in the worksheet?

Ex: 1. Add a worksheet
2. Name the worksheet referencing a field already defined.
3. #1 and #2 is automatic ( ran thru macro)

Please help.