vba & excel 2010

  1. C

    Scrub Excel table to show only listed criteria

    I have an Excel sheet with over 21,030 records (rows), that need to match against a List sheet with by two criteria. Criteria 1 = WUC and Crtieria 2 = POS. How can I vet the list to show only the listed criteria items? Also, list the criteria items not in the list being vetted? The List...
  2. tlc53

    Hide Command Button

    Hi, I'm trying to hide a command button if cell D8 does not equal 1, 2, 3 or 4. D8 is a dropdown, so changes manually. I have the following code below (which may or may not work) but I'm having difficulty including it with my other code (also below) as I keep getting errors. Can someone help me...
  3. A

    VBA to copy a column to another column with the same date at the top

    Hi I have an input column with the date of input at the top and number values on each row of that column (30 no.). I then have a table of weekly dates horizontally in another section of the worksheet. What I need is to copy the data from the input column and paste the values into the...
  4. A

    xlPasteValues not working, need to match destination format, but getting error

    Hi! So i have a data set that is exported by a database, so can't change it's format. I have a script to copy and paste it into my sheet and it works fine: 'set the range reference variables Set Bk = Sheet3.Range("C5") 'file path of book to import from Set Sh = Sheet3.Range("F5") 'sheet to...
  5. M

    vba coefficient trend line input the range

    Hello. I wish a real good weekend for all. I am loading the macro for the all coefficient trendline, first need to be editing (loop require), and the real point for me is to be able to write the range of "X and Y" variable for the all formulas from the location J1 and K1, I would like to be...
  6. C

    VBA Open file and convert to PDF

    Hello, a real novice here so excuse the probably simple question but I cannot locate an answer. I have a master workbook which contains lots of file paths to other workbooks. These locations change every month so to get around it I have a sheet which automatically updates the file paths each...
  7. X

    Extracting the number just after a text from textpad and writing in columns in excel

    I want to extract specific numbers after some specific words from textpad and I have to write that into my excel columns i.e example, the textpad file is like this *INFO* CRITERIA is MATCHED. DISPLAY ID 123456 AND AT T=369 MAY BE MATCHING OR MAY NOT BE *INFO* CRITERIA is...
  8. M

    From macro to vba

    Hello everyone. I am here trying to see the transformation from a simple Macro to a Code, I know guy for you is something so Simple, but “ sorry “ no for me, I am a new self-thaught bee. I just sum two numbers with the macro recorder I got this: Range("H2").Select ActiveCell.Formula =...
  9. M

    counting

    Hello. I have a little snipe code able to tell me how many times number 1 is in the column A, I am trying to count how many time 2 is after one, but still I don't know how to say that in VBA. This is the little code: Sub countmontecarlo()Dim cell As Range Dim n As Long For Each cell...
  10. O

    Outlook email using VBA

    Hi all, I am current in the process of trying to automatically send emails via outlook from data found in my excel spreadsheet. Here's what I've done so far; Sub Send_email() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("email") Dim Outlook As Object Dim msg As Object...
  11. C

    Applying autofilter then copying the sheets in a summary sheet from an excel workbook

    I am trying to apply autofilter and then copy the filtered results in one sheets using the below code . But it is throwing an "Object Variable not set error " Please help Code Sub CopyDataWithoutHeaders() Dim ws As Worksheet, DestSh As Worksheet, Rng As Range Set DestSh =...
  12. S

    Need to loop a macro to add salespeople's names and ID numbers

    Hi, I have the beginnings of some code to insert three rows below each row which has a name and ID to then populate those three new blank rows with the name and ID from above. I also have some code in the macro that should identify the end of the data (the first blank row) so that the macro...
  13. K

    Moving Bold items to other columns

    I have never created a macro in excel, and last night I was trying to and I created an IfBold Macro by reading on this website, however it did not really do I really needed to do. I would really appreciate any help I can get. I am this General Ledger Activity report that I need to convert to a...
  14. tlc53

    Hide Check Boxes when Row is Hidden

    Hi there, I have check boxes in column L (L20:L64) which I would like to be hidden, when the row is hidden. Currently all the check boxes are clustering together on L65 when any rows are hidden. The rows start off as being hidden and once data is entered in column B, the row below is unhidden...
  15. tlc53

    VBA Code - Hide / Unhide Rows based on Entity Type

    Hi there, Not had to write a code like this so have taken a stab in the dark but it's not liking it. Can anyone see where I am going wrong please? When I try to run it, the error highlights the second row of code (If Not Intersect...) The "Entity_Type" is located in cell D8. The "Entity Type"...
  16. R

    Problem Importing Data from Directory With VBA

    I am trying import data from 3 worksheets in a specified work book. My code works to delete the existing data in the destination wb. When I the code gets to the import commands it does not import. I have checked the file names and they match. When the resource actuals wb opens it is read only...
  17. tlc53

    VBA Code - Refer to Range and Rows

    Hi there, Can I refer to a range and row reference in one line of code? Eg. Case 0 Range("208:604").Rows("619, 629").EntireRow.Hidden = True So I would like to hide range "208:604" and single rows, 619 and 629. The above doesn't work. Thank you!
  18. D

    VBA Macro to read worksheet and output 10% each category in one column

    Hi All, I need VBA Macro to read worksheet and output 10% each category from one column. Data like this Name IDs A 1 A 22 A 33 A 444 A 555 A 666 A 777 A 888 A 999 A 1000...
  19. tlc53

    VBA Code Not Working / Error - Hide rows depending on 2x drop down lists

    Hi there, Before I go back to the drawing board, can anyone see whether they can get this VBA code to work? Basically, I have two drop down lists. One is "No. of Investments" and the other is "No. of Partners". I would like certain rows to hide, depending on the result of both drop down lists...
  20. A

    how do i make the formula so that if the other cell is changed then send an email also with a different recipient

    Hi I just learned VBA, I made code like this Dim xRg As Range 'Update by Extendoffice 2018/3/7 Private Sub Worksheet_Change (ByVal Target As Range) On Error Resume Next If Target.Cells.Count> 1 Then Exit Sub Set xRg = Intersect (Range ("c4"), Target) If xRg Is Nothing Then Exit...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top