• 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

    SirJB7, Luke M, Faseeh and NARAYANK991, Thanks for your help. It works. Now I can use a formula that references a drop down menu, which references a named range. Awesome.
  2. A

    Indirect Formula and Named Ranges

    SirJB7, Awesome problem solving. Your way works crisply and without trouble. I'm still hung up on using named ranges from drop down menu references in a formula. Since there's an error with the named ranges, could you see the file again with the named ranges removed? You can add the named...
  3. A

    Indirect Formula and Named Ranges

    Is it possible to reference a "named range" in a formula from drop down menus? My Columns are A,B,C,D, etc. My Rows are Jan, Feb, Mar... If I just write =A Jan - it gives me the correct value. But I want this formula to point to drop downs with the values "A" and "Jan" The attached has the...
  4. A

    Indirect Formula and Named Ranges

    I appreciate the help.
  5. 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...
  6. A

    Referencing a named range through another cell

    Learned a lot from this post - I have a question to build on this. I used named ranges on a table, using the "create from selected" method, selecting both "column" and "rows". The top row is months (Jan, Feb), and the Columns are names a complicated "G_All_Blah_Blah". I want to create a...
  7. A

    Time issue: CONCATENATE or MERGE?

    One thing, Nunes. It works for every value except 12:00pm and 00:00am. It always puts the opposite value. Any thoughts?
  8. A

    Time issue: CONCATENATE or MERGE?

    Nunes! You've done it! Nice work. What is the logic behind it? (how does it work?)
  9. 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...
  10. A

    VBA - WeekDay(Now) function giving Compile Error

    Thanks Hui and Krishnaoptif. Hui - your resulted in "Today is a weekend" for some reason (Today is Thursday). Krishnaoptif's worked well. So, the missing element was adding "Application." before the WeekDay function? Thanks.
  11. 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()...
  12. A

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

    Very nicely done. I appreciate your time. Do you know how to make exceptions? There are some tables where adding the date isn't appropriate. Kind Regards
  13. A

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

    I did the ctrl+down arrow and then inserted a row, then I grabbed the date from the column before and dragged down the cell to get the new date. I got the run time error '1004'. Sub Macro3() ' ' Macro3 Macro ' ' Selection.End(xlDown).Select ActiveWindow.SmallScroll Down:=9...
  14. A

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

    Excellent plan. Will try shortly.
  15. A

    Adding Sound to Button

    I did it on a blank module and it works! Beautiful! Now I can add crazy sounds to the macros. Fun!
  16. A

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

    I named them all according to what they record - eg, weight, overtime, etc.
  17. A

    Adding Sound to Button

    Hello, I get the error: Compile Error: Only comments may appear after End Sub, End Function, or End Property Any thoughts? Thanks, Alan
  18. 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
  19. A

    Retreiving data

    I may be showing my ignorance, but what function does the >0 part serve? I tried the formula without it and it still work. What scenario throws off the formula, so that you need the >0? Thanks, Alan
  20. A

    Displaying two column items in one row

    I figured out a workaround (I don't think we can post pictures in this forum?). Say A1, A2 and A3 have the cust #, Name and City. I went to my source data table and made a helper column with this formula - =A1&" "&A2&","A3 - that worked like a charm.
  21. A

    Displaying two column items in one row

    When I put them in Values, they show up as numbers - I've chosen all the options: "Count, Sum, Min, Max...etc". Customer Name is text, i.e. McDonald's, A&W, etc. And Customer # has a "C" in front of the number. How do you get them to show as text? I've done some googling but can't crack...
  22. A

    Displaying two column items in one row

    Hi Luke, Thanks for the snappy reply. Do you mean the values area?
  23. 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
  24. 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...
Back
Top