-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ezzzzzzzzzzzz
-
Create slicer for a list without pivot table?
Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...- Jyggalag
- Thread
- christian røssel conditional formatting easy excel ezz ezzzzzzzzzzzz fast format formula help hlookup index indexmatch jonas sværke jyggalag match peter lim pivot table slicer sverk sverkieboy sverknation svorkieboy svorknation svorkster svorktallica vba vba & code vlookup xlookup
- Replies: 4
- Forum: Excel Questions
-
Good way to hide rows?
Hi all, I have an overview like this: I am looking at four quarters for a year. I have a filter as well. I want to specifically hide the first three quarters somehow. However, please note that: 1) I cannot use a filter, because I often use a macro that wont work if a filter is on, and 2) I...- Jyggalag
- Thread
- christian røssel easy excel excel & ilogic ezzzzzzzzzzzz fast help hide indexmatch jonas sværke vlookup
- Replies: 2
- Forum: Excel Questions
-
Make VBA code that posts a cells formula as a value
Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...- Jyggalag
- Thread
- christian røssel code excel ezzzzzzzzzzzz fast formula goldstrome help hlookup jonas sværke lookup minus olzenmedz plus 1 sum sumproduct vba vlookup xlookup
- Replies: 1
- Forum: Excel Questions
-
Debug error with macro
Hi all, I currently have a macro that saves my sheet as a PDF, however when I try to do this, it brings me this error: If I debug it highlights this in my VBA code: The code is this: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As String Path = "R:Path\PDF files\"...- Jyggalag
- Thread
- christian røssel debug easy error excel ezzzzzzzzzzzz help indexmatch jonas sværke rossel sanoj ekrævs sonaj jværke vba vlookup
- Replies: 10
- Forum: Excel Questions
-
IndexMatch formula based on name of Excel Sheet
Hi all, I currently have this setup: Formula in full: INDEX('Q4'!$V$3:$V$73,MATCH(1, ('Q4'!$B$3:$B$73=List!$D651)*('Q4'!$A$3:$A$73=List!$N651),0)) My sheet used to be simply called "Sheet1". However, I have renamed it "Q4" now. I want my formula to pull in data based on the value in column...- Jyggalag
- Thread
- christian røssel code excel ezzzzzzzzzzzz fast formula help index indexmatch jonas svaerke match sanoj ekrævs sonaj jværke vlookup
- Replies: 3
- Forum: Excel Questions
-
Get formula that pulls a number from a sentence in a cell
Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...- Jyggalag
- Thread
- christian røssel excel ezzzzzzzzzzzz formula help if formula iferror index indexmatch jonas sværke jonassvaerke match olzenmedz sanoj ekrævs sonaj jværke text vlookup vlookup text & values
- Replies: 5
- Forum: Excel Questions
-
Help me fix my VBA code (attachment error)
Hi all, I have this code attached to a macro: Option Explicit Private Const FilePath As String = "R:\LXI_DLL\ZGJ_COMMON\FLD COMP FOLDER\12-FOLDER\TOPIC 2\ATTACHMENTS\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet...- Jyggalag
- Thread
- code easy ezzzzzzzzzzzz fast formula help jonas svaerke sverktallica svonkie svonkieboy svorkieboy svorkster svorktallica vba
- Replies: 2
- Forum: Excel Questions
