Functions

Names and numbers in different cells
I am trying to add the totals given in Columns C, E, G etc etc of each suburb listed in columns B,d,F etc etc. When the formula finds the total is also needs to give me the name in column 1 for that area. (Two areas given in example but not all week) Eg: Find "PNS Sound Hutt" in column B, & column D, add 2.0... 27 Feb 2010 02:22

Do you want to replace the contents of
When my macro runs, it stops after this procdure and asks "Do you want to replace the contents ofthe destination cells" is there something I can add that will automatically tell it yes? Here is the part of the macro that it stops on. Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _... 26 Feb 2010 20:55

worksheets
sheet1 is a summary page. sheets two thru 13 represent the months.on sheet 1 column 5 row 4 i've entered"=sheet2!r26. i would like to have that info placed in the same row but different columns BUT I WANT column 6(the adjacent column to read"=sheet3!r26". the next adj column i want to read "=sheet4!r26". i woul... 26 Feb 2010 20:55

drop down data want to choose more than one item for cell
I have a drop down box that i want folks to be able to choose more than one item from the box to go into the cell. ... 26 Feb 2010 16:29

Fred Thank you
I am using Excel 2003 but yes F9 does it. Works Great! I can't believe I was unable to find this info in Excel's help or Office online help! Something so simple. Amazing. Thank you, Doug ... 26 Feb 2010 13:06

Hyperlink to hidden worksheet
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Worksheets(Left(Target.SubAddress, InStr(1, Target.SubAddress, "!") - 1)).Visible = xlSheetVisible Application.EnableEvents = False Target.Follow Application.EnableEvents = True End Sub Daniell wrote: Hyperlink 01-Aug-08 Is it possible ... 26 Feb 2010 13:06

Nita Time formula
This was a reply to nita. Are all the cells formatted for time? I have them all formatted for time (13:30) and I get " #VALUE! " in the cell with the formula. Doug ... 26 Feb 2010 13:06

Formula for adding time
Are all the cells formatted for time? I have them all formatted for time (13:30) and I get " #VALUE! " in the cell with the formula. Doug ... 26 Feb 2010 13:06

Formula for adding time
Fred this works the first time but tomorrow when I change the time in b2 the time in b3 does not change. I have been formatting all cells for time " 13:30 ". Is this correct? Doug ... 26 Feb 2010 11:57

Pivot Table Calculations
Hello, I am trying to create a formula in a pivot table in Excel 2007 that will give me a percent of orders that have completed service orders. Here is an example of my pivot table data: Filter: on date Column: service complete: yes or no Row: Region Employee Values: Count of Service Order I ... 28 Feb 2010 12:15