Search results for query: *

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...

Thanks Keith. Do you know VLookup can be incorporated into a sum function? This is as some of the letters are interspersed thoughout the numbers, not in one set row or column I am working with a table such as the one below A 4 3 B B 7 7 6 8 and need to sum across rows, so if A = 10 and B=...

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...

Thanks Penny, Found this related thread (thread68-707576). The problem relates to Microsoft Knowledge Base Article - 292158 Used this to create the workaround. Olivia

Hi Penny, Thanks for your prompt reply. This did not help the document. I have since found 2 strange facts about this document. 1) If I remove the header, the page number (in the footer) displays properly (ie with numbers, not all zeros). Unfortunately I can't remove the header as it is...

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.

Did you ever get a Solution? Got the same problem myself?

Thanks for your help :) I ended up using a cross of both your codes to develop: Sub hyperlink_adder() Range("a1").Select 'select the column you want Do Until ActiveCell.Value = "" 'Add hyperlink ActiveSheet.Hyperlinks.Add Anchor:=Selection...

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...