User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Excel - Copy sheet and rename based on cell values Page [1]  
wdprice3
BinaryBuffonary
45912 Posts
user info
edit post

I'll pay you some $lafta dollar bucks.

I have a list of x number of names names that will correspond to worksheet names.
I have a template worksheet that I want copied x times and renamed using the list.

HOW I DO DIS?

List (say in Sheet 1, Col A, Rows 1 - 5)
DOG
CAT
MOUSE
LLAMA
DILDO

I want to copy a template worksheet (say, Sheet 2), x number of times (in this example, 5 times), naming each one after one of the names above.

11/12/2018 4:41:47 PM

synapse
play so hard
60940 Posts
user info
edit post

https://ccm.net/faq/27361-excel-a-macro-to-create-and-name-worksheets-based-on-a-list

I'd like to apply my $lafta-bux to some basketball tickets plz.

11/12/2018 4:59:28 PM

wdprice3
BinaryBuffonary
45912 Posts
user info
edit post

thanks, moderator

I owe you $lafta tickets

11/13/2018 5:22:46 PM

Novicane
All American
15416 Posts
user info
edit post

please sir, do the needful

11/16/2018 9:32:25 AM

 Message Boards » Tech Talk » Excel - Copy sheet and rename based on cell values Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.