vba code

  1. tlc53

    VBA Code - Sort by Custom List Reference

    Hi there, I am trying to sort my data which is located under headings A52:K52 by the account number order, as stipulated in cells K21:K35. This is my attempt but it is possible I'm way off the mark. Can anyone see how I can get this working please? I don't want to refer to a particular sheet...
  2. V

    VBA CODE EDITING - Search and Match and show the result

    Hi all, We are using the following VBA code Sub Search_and_Match() Dim sh1 As Worksheet, sh2 As Worksheet Dim lr As Long, lc As Long, col As Long, lr2 As Long Dim c As Range, f As Range, r As Range ' Set sh1 = Sheets("Sheet1") Set sh2 = Sheets("Sheet2") lr = sh1.Range("A" &...
  3. H

    VBA code for undo

    Hi, I am looking for a vba code for my module which will undo my works. thank you
  4. H

    Mandatory cell input

    Hi, I looking for a new vba code for these. In my workbook. I need to make B6 cell as mandatory or need to fill first before you can do other work in workbook. Also a message popup if they not fill the B6 FIRST. Meant after save and open if B6 are filled you can continue your work. Thank you
  5. A

    VBA MACRO TO Keep duplicates BASED ON CONDITION (Remove duplicate if the duplicate count of a particular id is greater 12 times

    In a sheet some 6000 rows are there. Id's are repetitive with different dates. I just want that macro will check the no. of repetition of each id and if the repetition is more than 12 times then it should delete the oldest date. (It means 12 times repetition is fine. If an id is repeated 13...
  6. P

    Need VBA code to copy and paste as values

    Need VBA code to copy and paste as values from a specific range A1:AE36 in a worksheet named "Matrix DSR" and workbook named ""Daily Sales Report Master Update File - CQ_v2" to a specific range A1:AE36 in a worksheet named "Matrix" and workbook named "BMH Daily Sales Report thru 08-21-19 run...
  7. V

    Create a line chart with flexible end columns

    Hi all thanks a lot in advance to the people that will help me with this. I have to create a line chart which should automatically updates according to the variable length of the columns of data that I want to display in my line chart. Any help/code that can help me? my line chart shows the...
  8. P

    Avaya CMS Supervisor R18 VBA code Error

    I current have macro set up to log in CMS and pull the need reports. This works fine for me however my co-worker gets the following error when he attempts. He had upgrade to Excel to 64bit but since has revert back to he 32 bit. Before the upgrade it worked just fine. Error Run-time error...
  9. tlc53

    VBA Code - Amend to include more references

    Hi there, Can anyone help me amend this VBA code to include more than one reference (if possible)? It currently refers only to D12 but I want to add another nine references - D68, D124, D180, D236, D292, D348, D404, D460 and D516. Thank you! Private Sub Worksheet_Change(ByVal Target As...
  10. tlc53

    Amend VBA code to refer to another sheet

    Hi, I have the below code which works fine if the target "No._Partners" is on the same sheet. However, in this case, "No._Partners" is based on another sheet. Can someone please help me change the first part of the code to refer to another sheet? I'm not quite sure how to do that.. Thanks...
  11. J

    Help :)

    Hello, I requested help a few month ago with this code, I was able to find a solution and customized like the following: Sub Externalabelshn() ' Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False...
  12. L

    Linking Multiple Cells to another Sheet with specific criteria

    I am having difficulty finding the best way to link cells from one sheet to another. I want to keep the rows together and only transfer info that has a blank recovery date. I have Columns B-L and 305 rows. In Column B, I have Dates of Service with other identifiable info in the columns to...
  13. R

    VBA code to copy range of cells in row based on criteria

    Good Evening, I have been searching for some time now for examples online and similar post for what I need with no success. I am here now to ask for assistance. I need a VBA code that will be run by a command button to copy a specific range of cells in a specific row and paste the cells to a...
  14. E

    Save and preserve VBA code on the new workbook

    I have the following code that separates and creates a new workbook that does not include the sheets "Main", "template" and promotes the user to save it at a desired location and exits out of the old workbook and keeps the new workbook that was created open. The code works perfectly however, the...
  15. C

    Using VBA code to prevent a button from making duplicate entries

    I am trying to crate an inventory tracking spreadsheet. I have made a button that moves entered information to another sheet. The button takes the information in cells A6:F:6 individually and applies the information entered to a list of parts on another page. The code I am using to do this is...
  16. S

    VBA Code to filter Sheet2 data based on Shee1 Cell Value

    Hi, Thank you in advance. Can you please help me with the VBA code so that when i enter value in Sheet1 A2 cell then Sheet 2 A1:P will automatically be filtered. Thank you. Shaikhstonevilla
  17. G

    Code for Deleting Multiple Rows Selected in ListBox (VBA)

    Hi, Currently I am into a project where I was stucked writing code for the below mentioned activity. I have created an userform with a multiselect Listbox and a Command Button ListBox populate the Items from a Table Source with 2 Columns. <tbody> Zone Region North N1 North N2 North...
  18. F

    Delete Blank Rows

    I need code that will: Find the first blank row in a set of data (the first blank row is ALWAYS at the bottom end of the data) Highlight that row and every row below it Delete I tried this code: 'Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete (I use Column A because that always...
  19. L

    VBA code

    Hello, I wonder if anyone can help me. I am a complete novice at VBA so please excuse me. I have some code, which opens another work book, "saves as" in a different folder then deletes the file. This is done to keep the links on a linked document when moving the linked documents. I want to...
  20. S

    Currency Converter to Different excel

    I have two excel first excel output file and second excel Exchange rate excel, first check in second excel date column and pick every month 1 date exchange rate and convert in Main file currency in (INR,USD,EUR) convert in GBP format. 1: Main Output file : Empno Ename...

Some videos you may like

This Week's Hot Topics

Top