help coding

  1. S

    Multiplying with cells based on a criteria

    Hi everyone, I am new to using VBA and not totally comfortable with Excel yet. I have a project where I need to multiply a range of cells with a value that a user inputs in a table. So if they input the year "2014" in a cell, then the value they input from that year need to be multiplied...
  2. L

    Automatically send emails to specific addreses within the worksheet based on a value within a cell

    I currently have an automatic email parsing system where it splits a recieved email into important sections such as name email and date email was sent. I need to send an email to the address in that row when the days lapsed cell in the same row reaches a value of 180. This needs to be done in...
  3. M

    vlookup match data and send an email

    Hello everyone! I hope you are doing well I'm working on a project and I need help please!! I have 2 sheets in my workbook Report and email.. The sheet "report" have all the data and sheet "email" have all the users email.. I would like the data shown in the report to go to the appropriate...
  4. M

    delete duplicate data in the same column

    Good morning!! Can you please help!! I wrote this code but I keep geting error I want to assign this code to pacific sheet the sheet name is Devices names. Sub Final2() ' ' Final Macro ' ' Workbooks("Mobile devices report").Worksheets("Devices list").Range("A1:A10000").Replace...
  5. N

    VBA Dropdown to Display Flited Results from Table

    Good morning amazing excel people! I hope you’re all well and enjoying the sunny weather, if geography appropriate. I’m really not to sure on a what VBA code I should use or if what I would like to do is even possible. The question; I have a very simple billing table that records appropriate...
  6. 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...
  7. Jyggalag

    Please help me wrap up my IndexMatch formula (90% done)

    Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...
  8. P

    VBA help coding (seems simple)

    Hello, I have a worksheet with data, where i have cable numbers with all the information how, type, from, to, routing etc. And i have a sheet with a pulldown to all the cables the of the form fills by vertical searching in the other sheet. So all information gets produced only have to do this...
  9. H

    How can I code VBA with named table

    Hi, I'm trying to create a league tournament for a 10 deck vs. 10 deck card game. For each victory I fix the score of the duel and click on a button to launch the macro which will implement the different tables. I name my tables with the name of the decks. My question: I have 2 dropdown menus...
  10. T

    Make blank cell actually blank....

    I can't figure this out. The code all works as required however... when referance "Lalllo" is pasted into range "I32" the blanks it pastes are not actual blanks in terms of what sub Clearvar is doing I get error message 1004 no cells were found. If I then manually click on each blank cell and...
  11. A

    Autofill Formula in next line

    Hi ive been working on a VBA project (Note: im still a novice and google everything I need to know) Ive developed a userform to capture some employee details and in the process to calculate the days to expiration of set dates against every new employee... The sting that I use are as follow...
  12. G

    Multi user login with diffrent rights

    hey! I have a multi user workbook i would like to ask for some help. I have crated a login sheet where i can write user id and password for this workbook. I have then crated a loop to make it look for the user if it match you get access. This is where i am stuck i cant get it to give different...
  13. A

    VBA Code Username/Time/Date/Sheets Stamp Shared Workbook With Macro Buttons

    Hi guys, Hoping forsome guidance on how I can achieve a log of activity to be automatically generatedwithin a shared workbook. Currently I have a functioning code for a single userbut I don’t think it can work for multiple users looking at the workbook at thesame time. Presently,the below...
  14. T

    VBA Help How to transfer column to an array in order to search and replace as quick as possible

    Below is a macro that stores the search items in an array and replaces with nothing. I couldn't include <P style*> in this array because it is replaced with a value. Unfortunately this bumps the completion time back up to how long it takes with a manually recorded macro. It was suggested to me...
  15. P

    VBA IF statment

    hello, I 'm really knew to VBA coding, and I was wondering if you guys could help. So I was wondering if anyone could help me with this code. I'm trying to make the if statement code for VBA, it can be either sub or function. ok so I'm trying to make if statement that says; " if active cell...
  16. P

    VBA IF statment

    hello, I 'm really knew to VBA coding, and I was wondering if you guys could help. So I was wondering if anyone could help me with this code. I'm trying to make the if statement code for VBA, it can be either sub or function. ok so I'm trying to make if statement that says; " if active cell...
  17. M

    VBA Code Needed For Word to Excel

    Hello all, Excel 2013 & Word 2013. I have a directory full of .doc files. Let's call it C:\BOM. I will generate a .txt file of certain files from that directory and save it as C:\BOM\BOM.txt. Example: BOM.txtC:\BOM\file01.doc C:\BOM\file05.doc C:\BOM\file11.doc C:\BOM\file47.doc I need an...
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
Top