Recent content by alanj

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 appreciate the help.

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

Clever!

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

Nunes! You've done it! Nice work. What is the logic behind it? (how does it work?)

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

Excellent plan. Will try shortly.