code

  1. Jyggalag

    Compile error: Variable not defined

    Hi all, Why do I get this error? When I run my code, it should send out an email. Thank you Kind regards, Jyggalag
  2. T

    Explaining what this VBA code means

    I have a code that copies data from column C or E if there's no data on column C from all sheets on the workbook except the master sheet But this code is not completely mine, I asked a colleague help to make it for me What I know is that it also depends on column G Can someone please explain to...
  3. R

    VBA Export to Text

    Hello Power Users! I want to create a macro to export a specific range, in a specific workbook to a .txt file. Then title the .txt file with a name from a cell within the workbook. Data I want exported to notepad as text: 1.Range: B2:N34 ---> Sometimes this range will be larger, so I would...
  4. Jyggalag

    Conditional formatting based on color?

    Hi all, I have this file: How do I make a conditional formatting formula (or whatever it takes) so if the COLOR (not the text!), but the color in column C is red, then the color for the respective cell ("hello" and "this" in cell A1 and A3) will also turn red? Hope my question makes sense...
  5. Jyggalag

    Error in vba code (macro) that saves my file in folder?

    Hi all, I have this macro: Once I press the macro "Save file to folder", I get the error above, and debugging it leads me to this: I want to save my file as a PDF file in the path above. Any idea why it does not work and how I can fix it? Kind regards, Jyggalag
  6. Jyggalag

    Create macro that copy paste's data

    Hi all, I am having a huge issue at the moment with some macros i created (through record macro). Basically, I have this excel sheet: I tried to record some macro's, where once I press unfreeze, they post this formula: =IF(ISBLANK(B9),"",TODAY()) for the left one...
  7. U

    Change folder name based off of selected cell

    Hi experts! I am looking for your help with a project of mine. This is what the end state of my idea is. When I place a number that is associated with a folder inside the orange box it will rename that folder "Folder" without a number. When there is nothing or a 0 inside the orange box all...
  8. Jyggalag

    Implement IFERROR formula for data in Pivot Table?

    Hi all, I have this data sheet: I have turned it into percentages and I assume that the top value (0.36% & -1.52%) are the sums of my columns (I am very new to Pivot, sorry). But I have #DIV/0! errors! :( Is there a way in which I can implement an IFERROR formula for my entire pivot table...
  9. Jyggalag

    Save file as PDF in VBA (macro)?

    Hi all, I currently have the following setup: I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF. However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...
  10. Jyggalag

    Make Power Query (insert data from folder) files delete or ignore first row

    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...
  11. Jyggalag

    Freeze =Today() formula once data has been entered

    Hi all, I am currently using this formula: With its neighbor formula in column C going like this: My question is whether it would be possible to somehow freeze my data in cell B3, C3 etc. going forward? So once the formula detects that a data entry has been in the cell 2 rows below it, it...
  12. D

    Clear content below row A VBA

    Hello, I am trying to find a way to use VBA to clear all cells below row 1 on an excel worksheet. Row A has headers I want to keep but would like vba code that I can put into a button to clear all cells under row 1, so clear rows 2,3,4, etc.. Also the sheet is called "User Info". So would like...
  13. P

    Excel VBA New Folder and copy an existing folder based on a cell.

    Good Afternoon, This seems to be a pretty common request, and I have tried other codes in other threads, but none of them are exactly what I am looking for. Heres the Goal: Create a new folder in a particular part of my server (This changes based on the information they put into the...
  14. Jyggalag

    IFBLANK formula but with specific text as well

    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...
  15. Jyggalag

    Pivot Table with Query

    Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...
  16. Jyggalag

    PowerPivot / Power Query & Pivot Table??

    Dear all, I have currently made a pivot table, which I am linking to some Power Query data. The data in the power query comes from a folder where I import files from a website, so these files will ALWAYS have the same file name, sheet name and column names. However, the data under their...
  17. Jyggalag

    Power Query question (never used before!)

    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...
  18. Jyggalag

    Filter in new data to pivottable sheet - help!

    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...
  19. Jyggalag

    Change my email macro to email multiple recipients in different rows

    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...
  20. Jyggalag

    Email multiple emails at once with macro/VBA

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

We've detected that you are using an adblocker.

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.
Go back
Back
Top