1. 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...
  2. 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...
  3. Jyggalag

    Attach subject of email to a cell value?

    Dear all, I currently have this VBA code (please note the part highlighted in bold): Option Explicit Private Const FilePath As String = "\\COMPANY.SSSS.COMPANY.NET\userdata\t5382304\home\Documents\TEST folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...
  4. Jyggalag

    Pull in data to a table of information

    Hi all, Does anybody have a nice template, structure or similar wording for a table of information with data being pulled in from a large master data sheet (I imagine through an INDEXMATCHMATCH / VLOOKUP formula, those tend to be the best options in my experience)? The nerdier the better :D...
  5. Jyggalag

    Macro to conditionally insert data from one sheet into another

    Hello everybody. I want to do something rather large, but I am very inexperienced in VBA and would really appreciate some assistance. Please note that I want to do a bunch of things, but if you can just help me with one of them, it would be immensely appreciated!! - Wishlist: @Fluff ? :) So I...
  6. Jyggalag

    Make a nicer trendline in bar chart in Excel

    Hi All, I currently have a setup similar to this: I want to create a trendline for the 2022 bar charts. My issue is that no matter which one I pick (exponential, linear, logarithmic etc.) it doesnt touch the top of the bar charts for 2022 and it seems to just go through them. Does anybody...
  7. H

    Macro to move cells from one column to another column based on value from cell (Calendar)

    Hi, I have just got a hang of macro but need some help with coding in VBA! I have a calendar with a lot of different activities placed in different cells. Let's pretend that my activities are A,B,C. The cells in the calendar (workbook A) will be externally referenced with data (dates) from...
  8. D

    Copy files from multiple workbooks into one sheet

    Hello all, I hope you are doing well. I'd like some help in making a macro that copies specific data from multiple workbooks simultaneously and copies them into one sheet. So: 1. I have these cells: All of which can change values. For example the jumbo can be ZJ2 or ZJ3. Then the user can...
  9. D

    Extracting data from current workbook to another workbook using file path that is in a cell

    Hello, 1. using VBA, i am trying to think of a way to copy values from a whole column in workbook1 worksheet "sheet2", starting from column F on sheet2 and X number of columns to the right and paste the values into another workbook, lets call it workbook2, and the worksheet the values will...
  10. S

    Userforms automation

    Hi, Hopefully someone on here is able to help, i am not familiar with VBA . i have a leave spreadsheet with 12 tabs for that calculates staff leave, their name in column B and the date in row 2. This workbook is read only for staff and only editable for managers. what i would ideally like is a...
  11. S

    VBA Vlookup code in excel

    Hi Everyone, i need support to write a excel vba code on vlookup of all sheets with different name from first sheet name"Sheet2" and put the information accordingly. number of sheets can vary. number of rows in every sheet can also vary. master sheet"sheet2" cloumns detail can also vary. all...
  12. Jyggalag

    Iferror(Index&Match&Match) formula

    Hi all! I currently have a large worksheet that is similar to this: With the master data looking like this: I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with [] such as [DATE]. So...
  13. K

    Error trying to select sheet with public variable

    I am trying to make a code that makes the program write data in a specific excel spreadsheet according to the value of the variable "MachineName" declared as public What happens is that the program does not allow me to do it because an error is detected on line 96 The error: The code...
  14. Jyggalag

    IndexMatch function not working, please help :)

    Hello everybody, I currently have something similar to this: Linking to this: It should return the date 21-06-2019 for XG10, but it does not. Can anybody see what I did wrong and how to fix it? Would be greatly appreciated! :) Thank you! Best regards, Jyggalag
  15. K

    Print Forms with data

    I am in an internship in a company, I was offered a job in VBA that I am not able to do, the project's goal is to take a print of all forms of the application and export them to PDF with the data that I was inserting throughout the process and insert those forms in a folder whose name would be...
  16. T

    Range of data to be copied in another sheet

    Hi, I have this code which helps me in saving data for two cells in different sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("M2").Address Then Dim intLastRow As Long intLastRow = Sheet2.Cells(Sheet2.Rows.Count, "A").End(xlUp).Row Sheet2.Cells(intLastRow...
  17. A

    Copy row from one worksheet to another with multiple column criteria

    Hello! I'm looking to copy an entire row from one worksheet (Sheet1) to another (Sheet2) based on multiple criteria. For example, in the image below, I need to be able to find all the "Green" fruits and then refine that further to only "Medium" Size. Then, I need to copy the entire row (as long...
  18. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  19. D

    Send/display email through Excel in Outlook

    Hello everybody, I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible? Furthermore, I know that you can do something like: Set.subject /...
  20. D

    We found a problem with some content in "File name". Excel annoying message

    Hello everybody, Whenever I open my excel sheet I get the following message: "We found a problem with some content in "File name xxx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes" It is super annoying. It started happening after I...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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