PC Review


Reply
Thread Tools Rate Thread

Range formula possible to update summary page with new entries when new sheets created?

 
 
StargateFanFromWork
Guest
Posts: n/a
 
      8th Dec 2005
I'm not sure what this would entail but is there a way to fix our summary
pages to include formulas or whatever that more automatically update links
from the sheets linked to them when new sheets are added to each workbook?

The reason I ask is because my colleagues are dealing with four workbooks
that each have about 15 worksheets minimum. Every time a new employee is
hired, a new employee sheet is created by copying one from another employee
and modifying the entries to reflect the new person. Unfortunately, the
summary sheet doesn't automatically include working links when they copy a
row on the summary sheet to a new row created for a new employee. They must
go into every single cell on that new row for every single new employee, if
I've understood correctly, and update the cell manually to put in the
correct sheet label, etc.

Is there any way to make this easier for my colleagues so they can do this
with less fuss and muss?

(I've tried to be clear as I know how, but if it isn't, pls advise and I'll
try again.)

Thank you in advance! D


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PLEASE HELP - Link Data from Different Sheets to Summary Page Link Sheets to Summary Page - NEED HELP Microsoft Excel Misc 3 5th Mar 2009 08:26 PM
A Macro for Multiple Sheets that Reference one Summary Page abergman Microsoft Excel Programming 1 13th Feb 2009 10:46 PM
Bringing data from multiple sheets to the summary page ExcelRookie Microsoft Excel Programming 5 11th Sep 2008 02:37 PM
Formula to get sum from one 31 sheets to a summary sheet. Eric Microsoft Excel Misc 7 24th Jun 2008 08:23 PM
Copy Several named Range in many sheets to a summary sheet =?Utf-8?B?RnJhbmsgU2l0dW1vcmFuZw==?= Microsoft Excel Programming 8 10th May 2007 10:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:46 AM.