excel vba 2010

Hi everyone, I need help with a VBA code to shift an existing table from right to left in Excel. I’ve attached two screenshots for reference: Screenshot 1: Shows the current layout, where the columns "Number", "Name", and "Salary" are in columns A, B, and C. Screenshot 2: Shows the desired...

I have a pattern of 25 cells (in column B) that I need to repeat many times over in the same column. The pattern is showing below: So essentially it will look as follows (ignore the colours please - just for ease of seeing the pattern): Thank you in advance for any help that can be provided.

I am in need of assigning a re-occurring number sequence to a large data set, based on cell value. A small sample of the data set shows below, in column A: I need to generate a re-occurring number sequence in column B, like showing below: So in column A, for every entry of AX1002, the...

Sub Changesavas() Dim FileSaveAsName As Variant Dim intchoice As Integer Static saveProcess As Boolean Application.EnableEvents = False ActiveWindow.ScrollRow = 1 Set FileSaveName = Application.FileDialog(msoFileDialogSaveAs) FileSaveName.InitialFileName = "E:\APLIKASI PKM\V3\" &...

Hello, I currently have thousands of folders with each of them having up to 10 .jpg image in them. My goal is to create a macro that goes over all folders, and for each of them, converts all .jpg files inside it into one PDF (1 img/page). I have successfully made the macro for one folder, so...

Hi, Thank you for reading this post. I need your help. I have some data an excel.. let's say column A has clients name and column B has clients email address. Column C sales figures. What I want is that I want to use excel macro so that 1) I can send email to each clients individually. 2)...

Hi i have userform with combobox 9 when you select combobox9 value it will show all the values into the each boxes and you can updated the textbox 19 value into sheet against the raw of the selected value in combobox9 however problem is if theres the same name e.g. twice same name in combobox9...

Hi i have main user-form 1 which has all the information including list box and when user select the name of the person it will find for duplicate and if user press Yes to duplicate msgbox another user-form 2 will popup requiring password and if user enters the correct password it will popup...

When I click a location and then the “ok” command button I want it display values from the entire column of the location I selected . can someone please help me figure out what is the code to do this ?

Hi, I have certain formatting (hiding of rows or resizing of a row) that needs to occur if new accounts are added/removed. I will have a macro button which can be run if they make any changes to the accounts. Cell K36 has a count formula and tells you how many accounts there are. Depending on...

Hi there, I have been working on an Excel file which has grown in size, with various VBA codes/macros. Recently it has taken a lot longer to save which I assume is down to size - 15,615 KB. Is this considered big in Excel world? Today though, I have had difficulty opening it. Most of the time...

HI guys i have getting a problem about my userform for updating records . i have 16 TEXTBOX in my USERFORM and to get the the data i use search button in my userform. well the problem is when after i search the data and update it when i click the update button the data that i updated was...

Hi, I am trying to populate values from the database sheet. I have already build combo box using vba. attached vba code below for reference. The problem is am getting only the first cell values of column item1. i need to get all the items selection branch,AGM,RSM,ALE,BRAND example: selection...

Hi Everyone. I am trying to use the VBA to filter the data then copy from one worksheet to new worksheet. However, how can I copy the specific range (i.e.: A100:E100) if no filter result return? Dim wSheetStart As Worksheet Dim wsDest As Worksheet Set wSheetStart =...

Hello Everyone, I hope you are well, So I have a form that has been working perfectly, but I have added some more code to it and now I am getting the Runtime Error 9 coming up. The form writes to an another workbook and the below still does that but then throws up an error. Dim...

I am new to MrExcel and new to VBA and hope you will help me. I used the following code to protect my workbook sheets before close and upon save and it works great but I can't figure out how to write it to allow filters to still work on all tabs of the workbook when protected. There are...

I create macros to find and replace texts in word documents. Consider the number of documents, I add a Cancel button to let the user to cancel the loop anytime. But the problem is, once the loop is started (start button is clicked) then Cancel button is then no longer clickable. How to keep the...

Hi everyone I’m trying to get an in cell data validation dropdown to work and I’m having no luck. Any help is appreciated. Here’s what I’ve got… I have two workbooks in the same folder 1. Reference Worksheets 2. Profile worksheets The Reference workbook contains (as of now, this...

Hi everyone, I'm using Excel 2010 VBA. What I need to do is filter my data set in two separate columns (Q and S) for values that contain 7 total characters, beginning with 2 alpha characters followed by 5 numeric characters (i.e. AB12345). All rows that do not contain values with that specific...

I'm using Excel 2010 VBA. Here is the issue I'm facing. I would like to insert a formula into cell Q2 and copy it down to the rest of the rows in that column (number of rows will vary). Here is the code I have, but I keep getting a syntax error. I don't why for sure, but I suspect it has to...