• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Rocky.Paredes

    Copying down formulas referring to horizontal data

    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...
  2. Rocky.Paredes

    How can I edit charts in multiple worksheets Excel 2010

    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...
  3. Rocky.Paredes

    listing all names of worksheets in a workbook and listing the value of cell T6 of each worksheet

    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...
  4. Rocky.Paredes

    SUBTOTAL function does not produce correct results when using time in hh:mm:ss

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