macro - auto run

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.

Hello everyone. I am a new member of this forum and I am from Hong Kong. If my English is not so good, please forgive me. I am now doing some manual entries and updates for the FIFO inventory system. As you can see from the picture cell "A5",originally, I have physical stock count which is 30...

I have a data sheet where i need data from sheet 1 column H to look up for data on sheet 2 in coloumn C and find the matching value and fill the data from rows adjcent to Column C into Sheet 1, Column J and K Basically its should be like the below concept Sheet 1 <tbody> REF DOB Quantity...

Hi, I've a macro which I run to validate if all the required sheets exist in a workbook or not. If no error, I run another macro to do some sets of action. Requirement: How can I automatically run the second macro based on first? I want to avoid manually running the second macro. Let me know...

I am new to Macros and VBA but have quickly realized the potential and I am working on automating a task at work. I would like to use a command Toggle button to copy data from one sheet into the next sheet every 30 min. The first sheet" Import sheet" is updated every 30 min with new data. I...