Automatically name a work sheet after data entered into it

[merskamp]

I have a database where 50 sheets come in each week. Right now they are names Sheets 1-50 but each sheet has a name on it (the names vary from week to week) - can I automatically get the sheet to name itself based on the name which is entered in cell c3?

 

[xapie128]

Re: Automatically name a work sheet after data entered into

I have a database where 50 sheets come in each week. Right now they are names Sheets 1-50 but each sheet has a name on it (the names vary from week to week) - can I automatically get the sheet to name itself based on the name which is entered in cell c3?

Use:

Sheets(1).Name = [C3]

Change the (1) to the appropriate worksheet number as required.

 

[merskamp]

This is a good start but i am a bit more beginner than most here - where do i put the code? Thanks.

 

[xapie128]

This is a good start but i am a bit more beginner than most here - where do i put the code?

That requires a longer, detailed answer than I have time for.
The first advice I have is to play with Excel's macro recorder and look at the macros to learn what it is doing.

Here is a forum thread that might help get you started:
http://www.mrexcel.com/board2/viewtopic.php?t=191250