1. D

    VBA copy value from one workbook, if value is X then paste a yes in a cell in another workbook

    Is there VBA macro where you can copy a value from a cell in one worksheet in a workbook and if that value is = to "X" In that cell then it paste the value "YES"/"NO" in a cell in another workbooks worksheet?
  2. D

    Copy the sum of two cells and paste into one cell

    I have a question, is it possible to copy the values from 2 cells in one workbook and paste the sum of those two values in a single cell in another workbook? Using a VBA macro Example, A1 and A2 in workbook1 worksheet 1. Copy the values of those two cells and get the sum of those two values, A1...
  3. D

    VBA - Loop files in folder, search column for keyword, copy range of text to spreadsheet

    Hello everyone, I'm trying to create a VBA program that will do the following steps 1. Loop through excel files in specified folder 2. Go through each file 3. Search in column B for "INTL" and/or "TRAX" 4. If "INTL" is found in column B, select that cell, move one cell over to column C, and...
  4. mrMadCat

    VBA from MS Outlook to copy data from excel file and past it to email body

    Hi! I have excel file which is saved locally in OneDrive folder but is shared within office 365 so can't use VBA. So I need to run a macro from MS Outlook to copy data from the excel file and past it in the new email's body. Here is the whole routine I want to automate: 1) Open the excel file...
  5. mehidy1437

    Adding more column in the arguments in VBA

    hi, how can I add column 1,2,3 here instead of column 3 only? I want to compare three column to get the unique value. str=ar(i, 3) Full Code Option Explicit Sub SumandRemove() Dim ar As Variant Dim i As Long Dim j As Long Dim n As Long Dim str As String n = 1...
  6. H

    MARCO VBA: Del Duplicate Row if match with 3 Col

    Del Duplicate Row if Col A, B, C matched I had thousand row, so possible to use macro?
  7. L

    using variables from other macro

    Hi How can I make the second marco print out the values from the first macro? for example I want to use the second marco to msg out x and y which are variable in first macro. Thank you so much. Sub myinputbox() 'to use msgbox Dim x As Integer Dim y As String x = InputBox("enter...
  8. H

    Macro: Auto Fill down on Col A & B base on cell

    The pic1 show original, and the marco will auto fill down as show in pic2 (yellow)
  9. P

    Copy specific data from Workbook A to Workbook B by a button

    I have set a button to run Marco for the subject action . However, the file name of Workbook A will change every day. I need to correct the file name of Workbook A in Marco before click button. I want to skip the correction step. Please help. Thank you.
  10. K

    Shortening a procedure for VBA

    Hello, I have a macro with VBA for this monthly chart that I make. I have a bunch of repeating lines of code that go for each day of the month but it ended up being too large of a procedure, so it doesn't allow me to execute it. I was wondering if I could get some help to possibly shorten...
  11. E

    Using a value in a cell to name a row

    Hi guys, I want to be able to use a value in a cell to give a ROW a named range name. The reason : I have 500 of them to name. I can easily dynamically pop the name I want for the row in a cell ( in this case I column G). Ideally, I want to write a macro to step through the rows, where it...
  12. A

    How to skip Worksheet_Change?

    Can I skip/disable a sub code before run my marco then recover it like as following: Private Sub progress() Skip run/disable Sub Worksheet_Change(ByVal Target As Range) My Marco Recover/enable Sub Worksheet_Change(ByVal Target As Range) End Sub
  13. O

    Macro/VBA to copy a range of data from a worksheet to a new workbook

    Please,can someone help me write a macro. I have an“A.xls” workbook where I want to open then copy a range of data to “B.xlsx” file. B.xlsxfile has the same format as a.xls so the data being copied will fit the samerange. I then want to password protect the new workbook (B.xlsx) and rename...
  14. C

    Macro needed for Formatting Print Area, Margins etc

    Can someone please help me with possibly an advanced macro. I process a bunch of different reports with different sizes, sometimes single tabs, sometimes multiple tabs, different rows or columns of data and different formatting etc. But every report I send has a few formatting requirements and I...
  15. O

    marco for totalling different length sheets

    I want to record a Marco to total column J and put the total at the end of the list. The difficulty is that I want to use this Marco on lists of various sizes. the curser May be anywhere on the sheet and when Marco is run it should always go to the end of column J. One sheet may be 250 lines and...
  16. H

    VBA for Hidden Worksheets

    Hi, How do you get a marco to work with hidden worksheets?
  17. G

    Call Marco to run from VBA

    Hello, I have written the following code, to copy relevant information into a different workbook, and then run a marco in that book. but it cannot find the Marco, "Macro3" Have I missedsomething? The data has pasted across,jut need t Marco to run. Thak Sheets("summary").Select If...
  18. B

    I have this marco that i need some help with.

    how do I get this marco to stop if there is no value in cell E3. Then let the user know that they must first enter a value in cell E3 before the marco will continue. answer = MsgBox(prompt:="Does CASH IN or CHIPS equalCHIPS OUT", Buttons:=vbYesNo + vbCritical, Title:="Update DaysValues") If...
  19. B

    Help with a marco

    I have a marco that copy's the numbers from A1 and B1. then pastes them on another sheet. I want to write into the marco that if "A1 does not equal B1" the marco stops working until the 2 cells equal each other. thanks in advance for all the help.
  20. U

    Marco to Paste data next to a to blank row

    Hello Mr. Excel members! I am stumped with a Marco need. Here is (what I think) is a similar macro I already have: Sub AddRow5() ' ' Cut_PasteSpecial Macro ' ' Range("C5:S5").Select Selection.Copy Sheets("Presentation for Approval").Select Range("A1:S1").Select lMaxRows...

Watch MrExcel Video

This Week's Hot Topics

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