I need to make a macro with many difficult functions

Closed
Shamus - Jun 12, 2015 at 07:18 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 13, 2015 at 03:06 AM
Hello,

I have a basic understanding of macros, but I have never written a macro, or developed something of this complexity.

The user of this macro will add in a name of the desired new sheet, into cell E9 on the first sheet called "NAMES". The macro will need to:
  • Duplicate an existing sheet called "P D"
  • Name the newly duplicated sheet based on cell reference 'NAMES!E9'
  • Link the entry in NAMES!E9 to the newly created sheet
  • Move entry from NAMES!E9 into NAMES!Column B
  • Sort Column B from AtoZ


Can you help?

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 13, 2015 at 03:06 AM
one way to learn to write a macro is to RECORD MACRO and take the steps and then examine the macro recorded and edit it functionally. first try simple one or two items. you will get a hang of it
0