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