Search results

Hi Somendra - you've given me a wealth of possibilities to choose from. I quickly tried your first solution and it works great! :-). I am really excited. Thank you so much! :-D. I will try the other solutions shortly. Again - Thank you so very much for your help. I really appreciate it!

It is fixed.

Hello Somendra - thank you for helping me. :-). This is all that I am trying to do. I wanted to write the formula so that next time that the horizontal information is updated it will also update the vertical info with the exact same information. C3, D3, E3, F3, G3, and so on 5, 10, 15, 20...

Hello - I am trying to copy down a formula that refers to data that is horizontal. Example: I have data in C3, D3, E3, F3 and so on. I want to copy down that data in column A2 so I will write the formula =C$3 on cell A2 but when I drag down the formula it does not change the column reference. I...

Hello - I hope everyone is doing well this Friday afternoon. I am hoping someone can help please. - I have to edit 200 charts in an excel workbook. - There is a chart on each worksheet. - Normally to edit data I would select a range of tabs on the workbook but it will not let me make global...

Hi Marc L. The code works great! Thank you for helping me - I really appreciate it :-) You're the man!

Hi - I really need some help. I am trying to develop a macro that will: listing all names of worksheets in a workbook on a separate worksheet and list the the value of cell T6 of each worksheet. The macro below will list the sheet names on a separate workbook but how do I get the contents of...

Ok - I understand now - Hui I apologize I just didn't see that option [h]:mm:ss.And thank you Narayan for clarifying this for me. It works! Thanks alot - I really appreciate the help.

Hi Hui - thank you for the warm welcome. I'm really excited about being part of the chandoo community. :-). My spreadsheet is already formatted in that way. Somehow the subtotal function using sum does not yeild the correct results. I also tried the same data on Excel 2007 - same result. Thank you.

Hi Narayan it is the subtotal: 0:00:47 + 4:52:14 + 8:01:04 + 2:36:40 + 10:41:47 = 26:12:32 - those numbers range from Cell D2 through D6. But the subtotal formula =subtotal(9,D2:D6) = 2:12:32 incorrect result. Thank you, Narayan I appreciate your time.

Hello friends - When I do a subtotal to add hh:mm:ss I get the wrong result but when I use the =sum() function it yields the correct result. The reason I would like to use subtotal is so that I do not have to manually perform the addition - could you help please. Example below. I use Excel...