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: Sumif over multiple sheets
Does anyone know how to get sumif to work over multiple sheets? I have information (models sold per sales member) stored in different sheets (1 for each month) and am trying to calculate the yearly total per sales member per model. The problem is that the sheets are sorted by total number of...- oliviaF
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Excel: Counting Letters as numbers
I'm trying to sum across a row of a table, where some of the entries are letters which relate to numbers i.e. A =10, B = 20 etc. The table of A=10,B=20 is located on a new sheet in the worksheet. The result I want is sum(a1:a3) = 15 + A +2 = 27. Does anyone know a suitable way to map the...- oliviaF
- Thread
- Replies: 6
- Forum: Microsoft: Office
-
Page Numbering Over Sections in Word
Anyone got any ideas why I can not use page numbers in sections other than section 1? In section 1 the page numbering works fine (1,2,3 etc). In sections 2, 3, & 4 all pages are shown as 0. This is destroying any TOC's as well. I am using Word 2002 on an XP box.- oliviaF
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
vb macro to convert string to hyperlink
I am trying to convert a string stored in a cell to a hyperlink. The string contains the location (ie "C:/temp") that I wish to link to. I also want the string to remain and be he handle for the hyperlink. There are ~1000 cells so I want to be able to use a loop to convert each cell in...- oliviaF
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
