automacro

  1. Y

    Extracting the same range from different workbooks

    Hey, First of all thanks for everyone who helps out. I’m new to this forum so hope my post will be as clear as possible. What I am after is a VBA code that will let me chose a file in my computer and then extract from it the rows from Q26-U(something) until the range end. in different...
  2. A

    Automatically Merge data from a specific range from multiple sheets(avoid blank cells)

    Hi, I need help please! I have this code but I need it to work automatically. The idea is= I need to gain the data from the range "A6:W29" but only cells with data and to do it in every sheet except for "RESUMEN" "S.Inicial" and "S.Final". Right now I can merge all the info but running the...
  3. T

    How to create and email an Excel Copy automatically (daily or real time)

    Hey guys, I am new here, and not an excel "expert" whatsoever, so I don't really have much knowledge of the code itself. I currently have a master file that is saved to our company's One Drive. This file contains 8 sheets in the workbook and at maximum goes from column A to column V. At the...
  4. H

    vba little change in code (entire workbook replace with one sheet in code)

    hi dears i have this 2 macro for excel to jpg convert and work perfectly , but my workbook have 10 sheets and i must repeat this code for every sheets . i need change these codes macro a : 1-for do it for entire workbook automativally and with no question 2-every export jpg file name is same...
  5. M

    Split cell and name columns

    Hello, Firstly hope everyone is staying sfae. I have a list of excel rows with cells like this: Product ID: 3943, Product Qty: 1, Product SKU: LPFL-B, Product Name: Gloves Latex Powder Free Size Large (BLOSSOM), Product Weight: 0.0000, Product Variation Details: , Product Unit Price: 14.95...
  6. Jaafar Tribak

    'Auto_Close' missing 'Cancel' argument

    Hi, I looked at a question posted in the forum which intrigued me to wonder if there is some way to abort the closing down of a workbook within the excel AutoMacro Auto_Close . Something similar to setting the Cancel arg to True in the Workbook_BeforeClose event. Any thoughts ? Regards.
  7. B

    Automatic goal seek function

    Hello everyone! I need a goal seek to run every single time the value in cell F1 does not equal zero. When this cell equals zero, that means my numbers tie, if it does not then I need to create a "plug value" to make that value in F1 equal zero. The cell that needs to change is cell D21. When...
  8. T

    Load excel macro when email received in outlook

    Hello! I need some help please if possible, is anyone able to write a code for me? I've had a look around online but struggling to find anything that can do the trick for me. I would like a script on excel to run when i receive a certain email in my inbox which goes to a specific folder. The...
  9. S

    Creating a New Suffix for a File Each Time Code is Run

    Hi all, I have a piece of code that runs and creates an output Excel sheet that currently has the run date as a suffix for the automatically generated file name. However, I now sometimes have to run this report multiple times in one day, which currently means overwriting the previously run...
  10. J

    how to trigger a macro from a scanned bar code?

    Hello, im trying to trigger a macro from a barcode example: im scanning bar codes cell1: SWGH cell2: SUIE cell3: ABYT cell4: NEXT<------ this imput triggers a MACRO called newsheet() is it possible? Thanks in advance.
  11. B

    Stop running OnTime macro when closed. Please Help!

    Hello! I'm really hoping someone can help me. I have searched and searched and I cannot find a solution that works for me. Our network at work has an issue that when we share an excel file, if anyone on Windows 7 (most of us are on XP) opens the file, it will automatically unshare it. So, we...
  12. C

    Using VBA to Lock Only a Finished Row

    I want to have each row on a spreadsheet lock when I'm finished filling in the information. Basically after the cell in the last column is populated, I want the row to lock to any further editing without a password. So far I've taken bits and pieces of code and tried to make it work for 1 line...
  13. H

    Open txt file in EXCEL automatically + auto arrange

    I have a .txt file from monitoring data. it comes in following format Example: 3,673,49,2,43,89,8,138,45,9,49,675 etc. 1) The data is in groups of 3 .. but comes as ONE string with commas. 2) 2nd number has a reference table for description in another Excel table Say: 673 | RRRRR 43 |...
  14. K

    Macro to change parameters on a dual axis in a graph

    Hi, I am having some trouble making a macro that adjusts a graph with a dual axis. I did some research and found one that only adjusts a normal x and y axis graph but I need one that can do both x and a secondary x-axis. https://www.box.com/s/5bc7ff7fd5118203ded2 I have the sample document...
  15. B

    Auto Macro

    I was given the code below but I cannot make it work. Even I placed an x in the A1 cell of blankSheet, I can go to another sheet and make a minor change before blanksheet is again activated. I am using this as a form of protection for intruders. What am I missing? Could someone help me with this...
  16. B

    run macro automatically in a loop

    ****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List"...

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