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.
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...
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...
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...
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...
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...
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.
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()...
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
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...
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
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
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.
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...
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
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...