[Solved] Macro to create and name worksheets based on a list

[ddavis1086]

Hello all.

I have searched and not really found what I was looking for. There is a need at my work to automat a spreadsheet and I hope it's not too complicated.
We have date that is exported out with a list on Student names in Sheet 1. I need a way to create additional sheets with the name of each student. Each students name is in a single column.

Would anyone have a such a way to do this? I do not have any programming expertise in Basic and have tried to do this myself but have not have any success.

Any help would be much appreciated. We are using ver 4.1 in Linux CentOS.

thx,

Dennis

[RPG]

Hello

I think you have search for the wrong solution for your problem. As long you think that macros and or new sheets is a solution for your problem I have the idea you are on the wrong way.

I think learn what you can do with some long tables in a spreadsheet. Maybe better start with a real database. It is maybe also a good idea to ask a real professional for your problem.

Romke

[ddavis1086]

I do not have nor can I hire a professional, but thank you for at replying.

[Zizi64]

Tips and examples:

viewtopic.php?t=20808
http://computing.ingreatway.com/2013/11 ... ove-sheet/

(And you can get the names of the new sheets from your list... to get strings from a cell range by a macro code is a basic task for a beginner. You will found example code snippets in this forum.)

[ddavis1086]

Thank you for the tips. Those links seem to be what I am looking for and will get me started. It's really appreciated.

[RPG]

Hello

I did seen an other post of you in an other thread.

Maybe after 10 day without a solution it is maybe good to tell about your problem in a way you can quicker to a solution.

I think do not continue with macro's. I will not help you with a macro. It means not I can give you a solution for your problem.

Tell first what you want with your data

Romke

[ddavis1086]

I was able to create a macro myself to get what I needed done.
This can set to resolved but I am not sure how to do that.

dennis