How to add a worksheet automatically using macro in xls?
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.
|