automacro

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

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

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

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

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.

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

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

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

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.

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

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

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

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

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

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