Use Macros to copy worksheet and rename using a list of names [Solved/Closed]

Report

eswhi

Posts: 1
Registration date: Saturday October 7, 2017
Status: Member
Last seen: October 7, 2017

- Updated on Oct 7, 2017 at 02:44 AM

Hi all,
I'm an excel novice and hoping for help.

I need to write a macro to
1. Copy worksheet "Alstromeria" and
2. Rename worksheet to the names in a worksheet 'List'. The list of names is from A1-A70.
3. Copy column data from "Master" worksheet.

Use Macros to copy worksheet and rename using a list of names
Excel macro create new sheet and rename - How-To - Excel
Recording Macro To Duplicate Page And Rename To Numeric Value ✓ - Forum - Excel
Macro to create worksheets ✓ - Forum - Excel
VBA Code to Copy Worksheet multiple times and rename based on list ✓ - Forum - Excel
Vba copy worksheet and rename ✓ - Forum - Excel

Use Macros to copy worksheet and rename using a list of names [Solved/Closed]

Your reply

Subscribe To Our Newsletter!