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

    Indirect Formula and Named Ranges

    I used named ranges on a table, using the "create from selected" method, selecting both "column" and "rows". The top row are months (Jan, Feb), and the Columns are names a complicated "G_All_Blah_Blah". I want to create a sumifs formula on another page that can cross reference a single cell...
  2. A

    Time issue: CONCATENATE or MERGE?

    I have a time sheet that comes to me in an awkward format. In Column B is the time, 8:00 and in Column C is AM or PM. Excel will default the date in Column B as AM. I need it to match Column C. When I do this: =B3&C3 - it gives me a crazy long number with AM or PM at the end. It can't be...
  3. A

    VBA - WeekDay(Now) function giving Compile Error

    Trying to practice using Subs with Subs. This example isn't working, though: Option Explicit Sub Main() Dim SubToCall As String Select Case WeekDay(Now) Case 1, 7: SubToCall = "Weekday" Case Else: SubToCall = "Weekend" End Select Application.rn SubToCall End Sub Sub Weekend()...
  4. A

    VBA - Add new row to end of table, with yesterday's date

    Hello, I'm a VBA newb, and I'd like to create a Macro to add a new row at the end of several tables, while entering the date into the first column of the new row. Any help? Best, Alan
  5. A

    Displaying two column items in one row

    Hello, When you put two items in the column field of the pivot table, say “Customer #”, and “Customer Name” – by default it shows the Customer # in one row, and then the Customer Name in the next row. Is there a way to get them to display them in the same row? Best, Alan
  6. A

    Conditional Formatting - blank cell gets unwanted format

    There is a formula in C1. Therefore, when I use conditional formatting to fill in the cells, it treats the formula as a really huge number, because it contains text. I know you can use the ISNUMBER formula, if you have 1 condition, but what if you have more than one condition? This is what I...
  7. A

    Adding Sound to Button

    Hello, I have a wav file that I would like to sound whenever a user presses a button in a spreadsheet. It is a boring workbook for my colleagues who work in the plant here. I thought it would be funny if they had a button that would make a donkey noise or a car crash when they pressed a...
Back
Top