I need to make a macro with many difficult functions [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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?

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
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