Notifications
Clear all
Excel Expert
2
Posts
2
Users
0
Reactions
85
Views
Topic starter
Hi
I have a list of codes on a sheet
abc
def
ghi
i want to automatically create an excel sheet that is named as per the codes So in this example I’d have 3 sheets created
1st called abc
2nd called def
3rd called ghi
how can I do this automatically?
Posted : 18/01/2020 7:24 pm
Hi Alison,
You'd need to automate this with VBA. Please post your question in the VBA/Macros forum as this is outside the scope of the Excel Expert course.
Thanks,
Mynda
Posted : 19/01/2020 9:14 pm
