Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formulas

Resolved · Medium Priority · Version 2003

Reply Thu 8 Apr 2010, 16:53Delegate Christina said...

Christina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Formulas

If you have 4 worksheets named:

Savings
Spending
Earnings
Total

Is there a way to pull through the worksheet names on the Total page next to the corresponding total amount?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Wed 14 Apr 2010, 11:47Trainer Anthony said...

RE: Formulas

Hi Christina, thanks for your query. There is no built in function to do this, surprisingly but with a bit of fiddling it is possible. This link explains the theory:

http://www.meadinkent.co.uk/worksheet-names.htm

...but try putting the following formula somewhere on each worksheet. It will output the name of the worksheet, and you can then dump that value onto the Total page next to the corresponding total amount:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Hope this helps,

Anthony

Reply Wed 14 Apr 2010, 11:47Trainer Anthony said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Tue 20 Apr 2010: Automatically marked as resolved.

Excel articles

· Working Together Is Easier Than Ever With Excel 2010
· How To Insert, Delete, Format, Hide, Copy And Protect Worksheets In Excel
· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010
· How To Protect Your Work In Excel 2010
· How To Avoid The Embarrassment Of Dirty Data

Please browse our web site to find out more about
excel training program and other Microsoft training courses.

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips