excel macro

I have a excel sheet where in Sheet 1, data start from B3 and in B3, the data are like 7, 131, 221, 222, 223, 224, 225, in a cell and in C3 and D3 a value is assigned against them, the cells are not merged. I want to separate the data 7, 131, 221, 222, 223, 224, 225 etc into individual cells in...

HI All, Am looking for a vba code to select a file from a folder and unzip the file in a different folder with different file name. Can you please assist me with the code. Thanks in advance.

Good morning/afternoon! So I have a little problem. I have a large data set shown below: And the following fields, where "Drilled Hole Volume" and ""Volume of Bolt" remain unchanged and static. The only field changing here is the "Volume of Cartridge". Basically I'd like some sort of VBA code...

Hi, I'm using a macro helpully provided by hiker95 on a previous thread some years ago, but could do with a bit of help please: It looks through col A which contains raw e-com generated address data held in one string. It uses a list of countries in col C to find matches and adds the country...

Hi All, I am new to Excel Macro and to this forum. I am trying to write a macro to copy a range multiple times. Please correct me if I am wrong. Sub Macro1() Dim x As String Dim x1 As String Dim x2 As String Dim p, q As Integer Range("A1").Activate p = 1...

I currently have a form in MS Forms, and I will soon have an excel spreadsheet with a lot of answers to the questions I have in the form. I was wondering if its possible to make a macro that reads all columns in a line and posts the answers to specific questions in the MS Form? Please let me...

Hello, I have been looking around for a macro that will save an excel sheet as a PDF with the following requirements: Named the same as the sheet Add current date select folder location I have been messing around with the following code: Sub Save_ActSht_as_Pdf() ' Saves active sheet as PDF...

Can someone help me with creating excel macro for the following. Data will be entered in the "Main" Worksheet Table. Shown entries for a project with two units - Unit 1 and 2. this could be multiple units. <tbody> Project Name "Enter Project Name Here" Test Date "Enter Test Date here"...

I have searched all through google and cannot seem to find vba code to get me to what Im trying to accomplish. I have named the following groups of columns by going to Fomulas, then Define Name. Columns V:AB are named "Position_1" Columns AC:AI are named as "Position_2" Columns AJ:AP are named...

I need vba code which will go to a certain cell that contains a groub of summation numbers and add another number from another cell ( value or formula) to them. So, for example: In cell "A1", "10" ( result from ("D1"+"G1") I need to add it to "B1" wich contain "=7+8+9" to become "=7+8+9+10", the...

I am writing a macro to open and update an Excel file in SharePoint online using Excel in Office 365. I can open the file but it open as read only. I found the solution to add ActiveWorbook.LockServerFile after opening the file but I get application-defined or object-defined error when I...

Hi, I am getting an undefined sub error message on this macro I modified. I am guessing its something very simple I did causing the problem. The macro is to copy and paste from one spreadsheet to another 2 different ranges ( offsetting Journal entries). The original code was to copy from one...

I Team, I need help with code for an excel macro, which sends users to another sheet in an excel table once a checkbox is checked, but does nothing if it is unchecked. I tried this already, but no luck: <code>Sub CheckBox28_Click() If OptionButton1 = True Then...

Hi all, I found a code to loop through the columns of a pivot table and identify the Columns that add to zero and hide them, but the code is stopping before it completes. The code is stopping at LastCol = Cells(GrTotLR, Columns.Count).End(xlToLeft).Column and I am not sure why. Also is there...

Hello MrExcel, I need to write a macro which will auto spell check as we write in the Excel (Dynamic spell check just like in Word). I know that we have this feature in latest versions of Excel , but we are currently using a older version and hence to customize the feature. Please do let me...

Hi, I have excel workbook that has 6 worksheets. and these sheets (tabs) are dynamic that can be changed if I change a specific cell (this cell has all several locations). Since I have more than 60 locations, I need a macro that can: - Build presentations for each location whenever I change...

Hi all, I am having an excel file which contains certain macros. I have locked / password protected vba project for viewing. This file will be used by certain users. I want to restrict circulation of this file. I want that only those users whom i permit / authorize should use this...

Is there a Macro that can be made to go to the first worksheet in an excel file - regardless of the name of the worksheet I am not a programmer and do not understand anything about Visual Basics. I was hoping to find some VBA Code that I can paste into the VBA Editor in order to do this.

I have a macro that I’m looking to make a small change to what cells get deleted after a copy and paste takes place. If someone could kindly assist. What I need to happen is as follows: Once a found number is entered in cell A1 (8 in this case) and is found in the cell range A20:A34 (cell B34)...

I have a set of data, Row 1-8 has information on when the report was pulled out. So my actual data starts at Row 9 onward, from Column A to Column P I have successfully applied filters for field 7 and field 12 as these were texts. However, Column I consists of dates (in d/m/yyyy h:mm format)...