stumped in excell

Forums: Computers
Email this Topic • Print this Page

I am trying to get a name from the spreadsheet to go to sheetname at
the bottom of the current active spreadsheet...can't figure it out
does anybody have suggestions or ideas? The workbook contains 50 to 100
sheetnames that are subject to change...I am stumped I do not want to have to go in and rename them everyweek(the tabs) the reference books I have do not help. Rolling Eyes

Topic Stats
Top Replies
Link to this Topic

Type: Discussion • Score: 1 • Views: 654 • Replies: 6

No top replies

Can you explain a bit more? I am not sure I understand what you want to do.

0 Replies

re:followup to excell stumped

Craven de Kere wrote:

Can you explain a bit more? I am not sure I understand what you want to do.

ok, I have a spreadsheet that has payroll information . I have locked out most of the sheet (lots of formulas that I do not want staff to paste and cut). I have a sheet that loads all the names into each sheet , but I have not been able to figure out how to name the tabs automatically as I have done with the sheets and link them so that the tab and the name load at the same time. Rolling Eyes

0 Replies

I'm not sure if you can name sheets automatically without a scripting language.

Hmm, maybe if you explained what your goal is we could find an easier way to do it?

0 Replies

Craven de Kere wrote:

I'm not sure if you can name sheets automatically without a scripting language.

Hmm, maybe if you explained what your goal is we could find an easier way to do it?

I am designing a payroll sheet for supervisors , it looks exactly like the hand written non pc version they have been using for the last ten years. The way it would gain acceptance is ease of use. In the test trials the work sheets were filled in and it took 6 hours to manually check. My design took 21 min and spotted several errors. The question on the tabs is that if I can't automate them then I will have to do all the changes re-name etc myself as I will not let them cut and paste me crazy....therefore I am searching for a way to be lazy.

0 Replies

Well, what you want to do is possible but you need to script it. Have you tried using an Excel Macro? This is one I found a while ago:

Code:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Sub Name_worksheets()

Dim Rng As Range

Dim rowcnt

Sheets("Sheetwithnames").Activate

Set Rng = ActiveSheet.UsedRange.Rows

rowcnt = Rng.Rows.Count

i = 1

For i = 1 To rowcnt

Sheets(i + 1).Name = Sheets(1).Cells(i, 1).Value

Next i

End Sub

Sheetwithnames needs to be replaced with the name of the worksheet that has the names in the row (with no header row).

You need to have all the tabs to rename created, this will not generate worksheets.

Then use this in your visual basic module. Make sure to back up your workbook. I have never used this snippet (I just keep these thing for reference).

0 Replies

This Visual Basic Macro might be easier. It copies a cell (A3) from the worksheet and names the tab:

Code:

ActiveSheet.Copy After:=ActiveSheet



ActiveSheet.Previous.Select

Range("A3").Copy

ActiveSheet.Next.Select

Range("A3").PasteSpecial xlPasteValues

Range("A3").Value = Range("A3").Value + 1

ActiveSheet.Name = Format(Range("A3").Value, "#")

0 Replies

stumped in excell

Related Topics

Quick Links

My Account

able2know