false

I cant seem to get my head around SUMIFS and VLOOKUP, Im currently using: =SUMIF('Gas July'!$B$2:$D$217, VLOOKUP($A3, 'Gas July'!$B$2:$D$217, 1, FALSE), 'Gas July'!$D$2:$D$217) Which points to a sheet with only July Data and multiple sites and it gives me the number I want (total usage for...

Hello colleauges, I came across a problem to be honest last time I used VBA was 3 years ago, so today I'm preparing a live sheet which shift cells dependant on cell value (product number). I tried to tweak around the code but it seems it just getting commands just from last lines of code for...

Hi, I want to loop through rows in my worksheet and compare the cell values in particular columns with other rows defining a variable as True or False (my segment_trigger variable below) if the values are the same or different. I have written the following code but its giving me "Compile...

Hello All, I have tried to search on the site looking for a way to use a record macro on any sheet within a workbook. I currently select the slicers and it will work on the original sheet created, but not one the active sheet. Sub Yonick() With ActiveWorkbook.SlicerCaches("Slicer_GSM")...

Good morning. I am working on the same spreadsheet described in this thread (https://www.mrexcel.com/forum/excel-questions/1112241-hiding-rows-using-vba-multiple-criteria.html) It is a sheet where based on the answers provided in a set of dropdown boxes, certain rows need to be hidden...

Hi, I have the below code which is returning an error, I believe near the bottom. It says I need to "End With" but when I put "End With" before "End Sub" it says it wasn't expecting "End With" :banghead: I'd really like this to run without any problems. Can someone please show me where I am...

Hi there, I have a sheet with 1500 records I'm trying to match to another sheet that has 700 records. The company name is not an exact match, so VLOOKUP is not an option. I built a tool with a macro for an advanced filter, and one to clear the data. The problem is that my filter is only looking...

<colgroup><col span="2"><col><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody> I recently added a search button to my userform, But it does not seem to search. I am trying to use existing Text Boxs for searching by either Customer...

Hello Everyone, I have a small problem with copying sheets from closed workbook "x" to my workbook "y". So the copying isn't the problem, just the formulas in workbook "x" because in this workbook I have formulash which referres to another sheet in this workbook. So when I am coping this sheet...

Hello, I have an issue with my auto-save macro on every 2minutes. It was working ok for couple of days, but now it is behaving odd. Macro is as follows (in Module1): Public dTime As DateSub MyMacro() Dim fPath As String Application.DisplayAlerts = False dTime = Now + TimeValue("00:02:00")...

I apologize if the title of this post is confusing. I have an Excel sheet that can have up to 10 entries. I have a drop down in AA3 with #'s 1-10. Based on the selection in that box, I need a certain number of rows to be hidden. If 1 is selected, I need a certain set of rows, if 2 is...

Just wondering if I can shorten my code a tad by changing grouped buttons with 1 command instead of two. For example: If you have a group of two radio buttons (for this example I'll call the group "NewEmp") and you want to lock or unlock them, do you have to use two commands (i.e...

Column B2:B7 is EITHER of 1 OR 0 Input Data Range D2:H7 is EITHER of TRUE OR FALSE Input ‘Header’ (above D2:H7) i.e. D1:H1 is 111, 222, 333, 444 & 555 Output Range J2:N7 as shown: How to accomplish. Thanks in advance I am using Excel 2007 Sheet2 <colgroup><col style="FONT-WEIGHT: bold...

Hello All! I was attempting to have a tab hidden based upon 'yes' or 'no' value placed into the cell of another tab. I have included my macro below (see very end for my issue) which is not working. :( Any recommendations appreciated! Thanks! Private Sub Worksheet_Change(ByVal Target As...

Hello All, I have the macro below that I was hoping to get some assistance on. Macro was working fine until I tried to both hide/unhide rows on the current worksheet and hide/unhide column on another worksheet based on response given in cell C24. Feel like it is something simple with the end...

Hi Why this formula is giving me 0 =IF(E2>50, ,) I thought it should give me True if E2 > 50 and False if E2 < 50 because I did not specify what would be if the condition is True or False. Thank you very much.

Hello, I have a VBA report I wrote. The report starts by Opening 2x CSV files Goal.csv (18MB) and Objective.csv (40MB) and copying their sheet contents to corresponding sheets in the report. The fastest now I can get the report to open is about 1 min. The open,copy, and paste process is taking...

Hi, I am trying to filter pivot fields and datasets through user input with multiple filters. Pivot filters works fine in isolation. I have tried different variations and could not find a solution how to make them work together. Dataset can not be filtered with 3 criterias, and I could not...

How do I disable the popup that says Excel is "SAVING AS" with the bar that shows % complete? Application.DisplayAlerts = False doesn't seem to help. Application.DisplayAlerts = False ThisWorkbook.Save txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")...

Hi, I used to transfer invoice data to another workbook [data], sheet "sales" and sheet"csales also add new workbook invoice sheet with below code, it took 3 second to complete. is there is way to speed up this process. Sub SavingSalesData() Application.ScreenUpdating = False...