macro - auto run

Hello, If I want to run a macro down multiple rows of data (sort of like autofill, but with running a macro), how would I do this? For example, lets say I want to copy A2, paste into a calculator on another tab, then copy and paste the output from the calculator onto a a different tab...how...

Hi I am creating one review record in this record I want to lock the particular cell of the data once the user was close the file (Save & close it ) . Example : There are column A B C in the table once the user enter the information in A1 B1 C1 and he saves then if he want to edit it he can do...

Hello Experts, I am working with 4 columns where I am in need of a formula where it will check if the director or directors of one company is exactly exist with the same name along with the same number of directors with the company just next to the first one. Let me explain it with a few...

Hello Experts, I am working with 4 columns where I am need a formula where it will check if the one director or directors of one company is exactly with the same name and same number of the company just next to the first one. For example please check the below table where for the both company...

Hie, So basically i have created a Excel File in which random numbers are generated. In which A1 Input Value A2 Low A3High These are the input values and the result is random numbers generated between the Low and high value, B5:B13 has this formula =ROUND(RANDBETWEEN($B$2,$B$3),-1). and B15 has...

I have found some VBA code, which works fine, that when I run the code from a workbook, it opens all the workbooks from a designated file. For example, workbook A macro opens workbooks B, C, D, E... and then closes it again. My problem is that each of the workbooks has external data that needs...

sheet1 gets new data added from an external source every 10 minutes. Column G contains numbers. I need a macro to copy some of the numbers (i.e. >2 AND <5) to sheet2 column B, without empty cells, each time that sheet1 is updated with new data. It sounds easy but I can't figure it out. How can I...

I have a problem, my users are missing on selecting a dropdown while working on a website (Intranet). I was looking for a macro which is continuously running, when a browser is selected by the user and clicks on "Complete Task" the macro must prompt the user that the Dropdown was not selected...

Hello, I'm currently building a disciplinary report log for work. The design of the log is simple; I have a table in Sheet 1 with rows corresponding to employee names. Each column represents a general category of possible infractions (e.g. safety; cell phone usage; failure to comply with...

Hi I am working on a document where I just want the users to be able to save only and for them not to be able to save as. Is there any solution for this?

Dear helpful people of Mr. Excel, I have been searching for an answer to this problem for quite some time now, to no avail. I have an Excel 2010 workbook, which keeps track of all the supplies needed for production at my store. Using a VLookup formula, which is applied to every cell in Column...

This is a little long but I want to explain why my problem is happening. I have a bunch of spreadsheets that have links to a master spreadsheet and they all reside in the same folder. These spreadsheets are used as design tables for Solidworks. When a Solidworks 3D model is opened Solidworks...

Hi! I am clueless about macros and would deeply appreciate your help. Is it possible to have a macro copy a row from one worksheet and paste it in a new row in another worksheet based on what value is in a cell of that row in a specific column? Let me give you an example of what I'm trying to...

Hello Everyone, Somebody please help me out to get VBA code for automatic Mail merge with To, CC, Subject, Attachments, Message Body as <tbody> TO CC Subject Message Body Attachments path </tbody> Since I am very new to Visual Basic, I could not manage to write all codes. I want to...

I have a sheet1 and sheet2 If I click on cell a1 in sheet1 then data should be copied to sheet2 a1(not formula) then I click on cell a3 in sheet1 then data in a3 should copied to next blank cell in column a of sheet2 that is sheet2!a2 not sheet2!a3

Hi, Here is a code: Private Sub CommandButton1_Click() Dim varNames1 As Variant Dim varNames2 As Variant Dim lngArr As Long Dim wb As Workbook varNames1 = Array("FIRST\GRAND EVALUATIONS.xlsm") For lngArr = LBound(varNames1) To UBound(varNames1) Set wb = Workbooks.Open(ThisWorkbook.Path...

I want to select latest report automatically and I created macro but code is something that I am not aware about. Can anyone please help me figure out what would I use that would allow to select latest report file? this VERSIONID I believe is taking date and time that I ran this macro and I...

Hi all: I need help on the following: Scenario: I have a master database of information in Excel Called Data. It has a lot of fields. I have a form that I need to automatically filled with each row data from the master and then a save the form with a specific style (AgencyName_SiteAddress in a...

I am very new to the macros.I want to know can we develop a macro to download report from online website.based on the names which i can select form drop-down list,i want to download same reports for each name.can i do this using macros. Please help me to do this.