Hi all,
I have this formula:
Essentially, when I fill in ANY data or make ANY changes to cell D2, i want the VBA to automatically update the current date/time in cell B1, so I can see the last time I made any update to cell D2.
I can do xOffsetColumn = -2
But this will show the date in...
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...
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
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...
Hi all,
2 questions:
1) I have the following setup:
I add new files quarterly to my excel file, so Q1 2021, Q2 2021, Q3 2021, Q4 2021, Q1 2022, Q2 2022 etc.
Right now I only have one for each year, but I plan to add many more going forward for 2022-
Does anybody have a way in which I can...
Hi all,
I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why?
Thank you!
Hi all!
I currently have this setup, please note that I have hidden all the nonrelevant columns however:
The formula I use is this (thank you @RoryA !)
=IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...
&indexdd
code
column
copy
copy formula
copy paste
easy
fast
formula
formulas
help
hlookup
indexmatch
jonas sværke
madzi
madzi emil grell
olzenmedz
paste
vba
vba code
vba column letter
vlookup
xlookup
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\"...
Hi all!
I currently have this setup (albeit with more columns in reality):
I would like to sort it by dates first, and then by the number after. However, I want this done, so it respects the date assortment before the number assortment, so it wouldnt for example put:
1 - February: 1
Before...
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...
Hi all,
I currently have this VBA code:
Option Explicit
Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i As Long
Dim ws As Worksheet
Dim col As...
christian røssel
code
easy
fast
help
hlookup
htmlbody
index
indexmatch
jyggalag
match
olzenmedz
pdf
røssel
røssele
sanoj ekrævs
save excel
save pdf
vba
vlookup
xlookup
xlxm
xlxs
Hi all,
I currently have a data overview that draws data through power query from a folder in my windows computer:
However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following:
1)...
Hi all,
I currently have a bunch of files that are 99% similar, except they have some different data in their columns. The first two rows will always look like this:
Unfortunately, the first row messes with the power query, so it returns this:
If I remove the first row, my file works such...
code
conditional formatting
easy
excel
fast
formula
help
indexmatch
jyggalag
macro
pivot table 365
power cable
power query from folder
svorkieboy
vba
vlookup
Hi all,
I would like to create a macro where, once I press it, it saves my file to my folder \\COMPANY.MDDD.COMPANY.NET\userdata\t654895\home\Documents\test files
Does anybody know how I would go about in doing this? :)
Thank you!
BR.
Jyggalag
Prince of Order est. March 26, 2007.
Hi all!
I have this formula:
But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell.
Can...
Hi all,
I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query.
I want to import data into this pivot table (not using power query below):
I have the source data saved here:
So questionnaire data file 1 is week...
Hi all,
I currently have a sheet that looks like this:
(Please note that I have divided my excel file into two windows, so you can see both sheets at the same time).
I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my...
Hi all!
I currently have this setup in Excel:
And the code is this:
Option Explicit
Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t543932\home\Documents\TESTfolder\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i As Long
Dim...
Hi all,
I currently have the following setup:
The macro will send out an email to the 1st contact and BCC with this VBA code:
Option Explicit
Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t865934\home\Documents\TESTfolder\"
Sub send_email_complete()
Dim OutApp As...
Hi all,
I have the following code for HTMLBody:
SendEmailTo.HTMLBody = "Dear all,<br/>" & "<BR>" & _
"bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text ""bunch of insignificant text"" bunch of...
Hi all!
I have the following email macro:
Now, what I am wondering, is whether it might be possible to ignore certain emails from being targeted on the list that I have designed in my "for i = 2 to 10" code? A nice solution personally for me would be if I could simply just highlight the cell...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.