This macro successfully selects the second empty cell below the last used one in D5:D300 Code:         Dim emptyCell As Range         For Each emptyCell In ActiveSheet.Range("D5:D300").Cells         If Len(emptyCell) = 0 Then             emptyCell(2).Select             Exit For         End If     Next I'm now trying to bring data in from other cells to satisfy a formula I'm placing in the selected cell. My problem is that as the selected cell w ..read more

Looking for help with some conditional formatting. Yearly calendar being used for weekly garbage and recycling pickups. Year can be selected and the data updates automatically for each week/month, or at least that is the goal. Most of it is working and I'm sure there are better ways to do what is being done already, but here's what I need help with specifically. - Pickup days are on Tuesdays. A week is Yellow and B week is Blue. Problem 1 - Holidays that fall on Sun/Mon/Tue shift pickup day to Wednesday. There are only 5 months with Holidays that impact pickups, but Red Holidays are working an ..read more

Hi all, First time poster here :)) Simplified, I have a cell, lets call B1, that will refer to another cell (C3) on different sheet using INDIRECT(). The problem is I want the value of C3 to change depending on what the cell NEXT TO B1 says (i.e. value of A1). Basically like IF A1 = "lorem" >>> C3 will = [lorem result] >>> therefore B1 will = [lorem result] too but if A1 = "ipsum" >>> C3 will = [ipsum result] >>> therefore B1 will = [ipsum result] too I need it to apply to multiple rows as well. So it could be A2 & B2, A3 & B3, etc referring to ..read more

Hello from El Paso Texas! Just trying to knock out this excel project and I am HORRID with formulas lol ..read more

Is it possible to match a name with a job when the name is in column and the job in another table row along with the name? I have attached a sheet as I'm having trouble articulating what i need. I have a long list of People and then their associated jobs. I need to combine this into a table that has the person's name in the column and an x below their name if they can do that job. Thanks, Jason Attached Files Match two columns.xlsx‎ (9.3 KB) Download ..read more

I have a sheet called "Pivot Table" and B2 contains a Pivot table (Pivottable1) , which the filter for period month I have tried to write code so when opening the file, the number in the filter is selected based on the number in F2 on sheet "Imported Data" eg if F2 is 6 , then filter in B2 to select 6 Kindly check and amend my code Code: Private Sub Workbook_Open()     Dim ws As Worksheet     Dim pt As PivotTable     Dim pf As PivotField     Dim filterValue As Variant         ' Set the worksheet containing the Pivot Table &nbs ..read more

How do you use the InputBox to select named shapes? I have three shapes I use as buttons. Every button looks like this: Code: Sub Button_alpha_L1() Dim shp As Shape Dim rng As Range   Set rng = Application.InputBox _   (Title:="1/6 Select Cell", Prompt:="", Type:=8)   Set shp = ActiveSheet.Shapes.AddShape(9, _     rng.Left + 5, rng.Top + 4.5, 9, 9) 'SET   shp.Shadow.Visible = False   shp.Name = Application.InputBox _         (Title:="2/6 Enter Name Level 1", Prompt:="", Type:=2)   shp.Fill.Visible = True   shp.Fill.ForeColor.R ..read more

When I add an employee to my list, it doesn't transfer over to my main sheets in the drop-down menus. Can Someone please check why. Thank you. Attached Files Employee absence schedule.xlsx‎ (113.0 KB) Download ..read more

Hi, I am trying to organize my membership database download. I can see that someone has renewed by manually scanning the list but my real list has 400 members. Is there a way to organize the excel worksheet by name and if they are current(paid within the last year) or they have not renewed. I am kind of lost. I can pivot by name and get the summary of their membership but cannot figure out how to identify if they are current or not without manually scanning the table. The answer that was supplied previously by excelforum was great it took 1013 lines of membership data and gave me an array ..read more

I was trying to see if it was possible for a Table title reference formula, to both be text and a reference cell. Normally I would do this in a cell, but in tables it doesn't work. ="Test "&A35 Thanks for any help. Nick ..read more