Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Sum formula across worksheets
We have a workbook with over 20 tabs, is there an easy way to add the same cell in each tab, without having to click on each cell in each workbook? ie: =('2003'!C374+'2002'!C374+Sheet3!C374) thanks Mandy- Vmanda
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
New user id, can't access previous synched files
We've been using xp for a couple of months now and using the file synch. Recently we upgraded to an active server directory and assigned new ids and a new domain. One of my users was away on business while this happened. He is back in the office and logged on using his new id and can't find...- Vmanda
- Thread
- Replies: 2
- Forum: Microsoft: Windows
-
Custom Function - passing an arg. as a worksheet name
Hello, I am trying to write a custom function. The function takes two arguments, state & HazardGroup. Depending on which state is used, the range will be based on a different worksheet. I would like to be able to use the state arg to choose the worksheet, but I haven't been able to get it to...- Vmanda
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
