vba & excel

  1. N

    How to link to subfolder with current VBA Macro

    Hi, I have the current code that works to pull directly from a shared folder's inbox. I need it to pull from the SubFolder "Shared Email box" > Inbox >>"SubFolder". Can you please tell me how i can modify the below? Sub GetEmails() 'Add Tools->References->"Microsoft Outlook...
  2. J


    Hi all I'll be appreciate if you help me with my problem. I have a large table with more than 5000 rows with more than 700 section, each section have their own data in about 7 to 11 rows and what i need is to have a code to sort each section with my selection rows and sorting them by column Q...
  3. J

    Data Validation - To Stop the User Inputting more than one Specified Value in a column

    Hi. I have a question about data validation. Is there a way to remove one of the strings from data validation list if it's already been used in a row above in the specified range? A quick example of what I mean. Lets's say in column A1:A30 each cell has a data validation list of 'A', 'B', 'C'...
  4. R

    VBA Code - Loop through rows one by one copy perform calculation and paste in another sheet

    Need help in coming up with VBA code logic . My requirement is as follows: Sheet1 (Input Sheet) ProjectID ProjectName 2022 2023 2024 Project 1 Name A 100 200 300 Project 2 Name B 400 500 600 Project 3 Name C 700 800 900 Sheet2 (1st Output Sheet Read the first entry from...
  5. J

    Macro - Create Tab Delimited *.txt from range

    Hello Excel experts! I am in need of a macro in Sheet A that creates a tab delimited blocks.txt file from range A36:C50 in Sheet B in directory C:\Users\user\Desktop\AsBuilt\blocks.txt Also, since I will be using this same file to import blocks in AutoCAD, I wouldn't mind if the newly created...
  6. B

    Unable to merge cells

    I am intending to merge every cells between the two objects "FirstCell" and "SecondCell". Still a relatively new user to vba, hence not really sure what went wrong. I have also declared "EmptyRow" in a previous function. Thank you!!!
  7. S

    Can you help me debug this code?

    Dim lastRow As Long, i as long lastRow = ThisWorkbook.Sheets("report").Range("b1000000").End(xlUp).Row lastRow = lastRow - 1 i = lastRow ThisWorkbook.Sheets("report").Range("c&i:p&i").Formula = "=SUBTOTAL(109,$c$2:i)" What is meant by the code is to add a sum to specific columns starting from...
  8. K

    VBA-Macro Help with copy data from 1sheet into another sheet multiple times

    Hi Mr. Excel, I need a logic that would copy Sheet1 (Data Table) into Sheet2 Sheet2 (End Result should look like this) In this sheet, MaterialA should be repeated 13 times and each of the months values should be copied vertically against the respective month. I needed help on how to do this...
  9. P

    Excel Business Translate with VBA

    Hello, Can anybody share a reference on how to use Excel Business Translate (Excel - Microsoft Translator for Business ). I was not able to find any references. Thanks!
  10. S

    VBA Column Finder

    Hi All, I'm new to this forum so I apologize if the question has already been answered. I am working on a spreadsheet that fills out shipping details to a customer. What I am looking to do is execute a VBA code that will locate the column and perform the vlookup. Typically, I would just create...
  11. dss28

    prevent Clicking "End" to close the form when run time error is shown

    In my program if the user does not proceed with the correct method of clicking the row in a listbox to select the row and then click on the delete row button, error message 381 is shown. if the user now clicks on "End" button the form totally closes and the login window is shown. if the user...
  12. S

    Vba to find text in sheet1 cell content from sheet2

    HI Team, I tried to find solution to my query on mrexcel forum. unfortunately, I did not get exact solution to my query. Here I need a macro to get the sheet2 ColumnB data into sheet1 ColumnE. Macro to vlookup sheet2 ColumnA data in sheet1 ColumnC text if found get Sheet2 ColumnB data into...
  13. K

    Pastespecial from excel to outlook using VBA

    Hi guys, I need some help in my vba code. I am trying to pastespecial a screenshot of my excel file into email. For some reason unknown, I always get an error message when I try to compile the code- compile error can't find project or library. Strange enough, when I change the code to paste...
  14. D

    VBA for Excel Schedule

    Hi guys, I'm really hoping someone can help me. I'm wanting a schedule that will hold up to 30 appointments per time slot per day. I have created a calendar that you select the day on, then select the time and fill in the appointments as necessary (please see screen shot). I've managed to get...
  15. M

    How do I keep my formulas from changing when I run my macro?

    I have a rather large workbook I use to analyze data from different sources. I copy and past data into 16 different worksheets and then use VBA to format the data so it's readable. The data is pulled in to a single worksheet I use to rollup all of the information into a table with a pie chart...
  16. A

    VBA code for text filter and then median of data

    Hi, I have a workbook with multiple worksheets within it. For each sheet I want to filter based on the contents of one column but need the filter to work like the search autofilter i.e. to filter based on the contents of the cell containing any part of the term not the whole. An example of this...
  17. S

    Algorithm / Code to find dependency and build row column wise hierarchy model using VBA

    Suppose I have two columns ColA = Calling programs and ColB = Called programs, now I want to build a hierarchy between calling and called program and print them with the calling dependency lvl column as below. Note: Calling program for which called program is SPACES, is the initial program...
  18. N

    Calculate how much of a roll will be used...

    Afternoon, My son is setting up a vinyl wrapping solution for interiors, and I was hoping to create a calculator for how much vinyl he would need to purchase for each job. Does any one know if there is some vba to calculate how much of a roll 2M Wide x 15M long would be used from a mix of...
  19. C

    Transposing Data from two columns with a common data identifier into another column one row at a time

    Hi Guys, I am wondering if there is a way to transpose data that are in two columns B & C,ie (Attribute and Value) relating to a unique reference id, that is in column A (Product Code) with B & C grouped together separated by a colon : and each Attribute: Value combination is separated with a...
  20. S

    VBA to format left header specific text

    I wanna change the font and size of the entire left header and make part of that header Bold. Since this doesn't have a cell reference I'm having difficulty trying to figure out how to do this. Advance Thanks for all the answers. Note that the header info is being fed in using a userform to get...
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 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