vba & excel 2010

  1. N

    Colour Pivot Filters When Active

    My goal is to highlight the cell when I have a filter active in the pivot table row & column labels. I have found the linked document below which shows me how to accomplish what I'm looking for in regards auto filters. What I would like to do is perform this same action in a way that functions...
  2. F

    Group rows with same value in column B and set different background color for each group

    Hi, I have data in a sheet with something like this: <tbody> A B C D File1 Abs 145 YuoJ 002 RFG 234 3op 009 File2 UYR 234 yyt 3nn POC 778 www 334 File3 WEF 778 O93 R67 TRE 778 87K 004 </tbody> I would like to colorize with the same background color all rows that...
  3. B

    VBA question: How do I reset filters before setting a new filter?

    Hi, Columns A:G in my spreadsheet contain "Yes" or can be blank and there may be rows where there is more than one "Yes". I have a dropdown in cell K2 where I can select the names of one of these columns and then I want to filter the data based on that column. There's probably a better way...
  4. tlc53

    VBA User Multiple Input Window

    Hi there, I would like 3x input boxes to popup asking the user for information. When I just add the code for the first one, it works fine. However, I get errors when I add the next two codes. How do I amend the code so that each box pops up one after the other? Thank you! Sub ssFav() Dim...
  5. D

    Copy data to another workbook based on search results

    Hi I'm new here, I'm Debbie and hoping to get some help with a holiday and sickness planner I have been creating. I am looking for a way to copy data from one worksheet to another in a different workbook (I'm using Excel 2010). I have identical column headers in two worksheets, columns D...
  6. L

    Speed up VBA using Countif, Index & Match

    Hi all. I had some great help recently which has spurred me on to learn more and more VBA however I have a problem with the code below taking about 15 minutes to complete and wonder if there is a more efficient way of returning the required data. Even if I turn off calculations, I need to...
  7. M

    Loop through slicer in pivotable prints too many pages

    I found a vba code that I copied on this forum that lopps through a slicer and selects / deselects each name and bring up the relevant data for that person and prints it. It works but for some reason it keeps creating prints about 104 pages when there are only 39 names in the slicer. The last...
  8. U

    VBA: Concatenate data with and without symbol from respective rows

    I have data with symbols like "|" and "~" and ":" from H to say N column. With VBA (using switch statement) get, In Column B and C: Concatenate data with and without "|" from respective rows In Column D and E: Concatenate data with and without "~" from respective rows In Column F and G...
  9. F

    Excel vba macro to convert long numbers correctly

    I have to convert a text file into excel 2010 for which I have written a marco This file has column that contains long numbers and alpha numeric data. My issue: I have converted cell into Text(script below), alpha numeric number is fine however, when there are numbers more than 20 digits...
  10. A

    VBA: Run excel formula in a range a1:x100 without changing any value with automatic update and error.

    With VBA how to run excel formula in a range a1:x100 without changing any value with automatic update and error.
  11. U

    Simple VBA: Delete data in bracket

    VBA: In all excel book sheets, delete data in the bracket after the period character that appears without gaps. For example: ".(5,6)" will become "." For example: ".(4,3,7,10)" will become "."
  12. G

    How does one use Excel VBA to merge data between workbooks & Import new recently added data?

    Hi All I am very green to VBA so apologies for the massive gaps in my knowledge or if this has already been answered but I am struggling to find a code that covers what i would like to do. So i have to two workbooks, WB1 has a list of my projects (address and job database which contains the...
  13. tlc53

    Lock edited cells with Macro Button

    Hi there, I have found instruction on how to lock cells immediately after data has been entered however, I'd like to lock the cells with a push of a button/macro. Is this possible? Data is currently entered in B12:K105. I would like it so when they hit the "Transfer Journal" button, any cells...
  14. tlc53

    Delete Entire Row when two cells are blank

    Hi there, Data is entered into range A9 to L (row unknown as data keeps being added). I would like a macro to delete the entire row if BOTH the cells in column E and F are blank. If only one is blank, it shouldn't be deleted. I'm not really hitting the mark so far with my code. Sub...
  15. D

    VBA Pivot Table - Run time error 13

    Hi Just copy the code from online for Pivot table filter base on Cell Reference. Its working fine f no ("blank") in filter. Its blanks its shows Error so i add this Code pf.PivotItems("(blank)").Visible = False Now i getting Run time error 13. Its Date filter base on cell Reference, Any one can...
  16. tlc53

    Macro to add date to column

    Hi there, Can someone help me write this VBA code please? In column K (from K9 down) I have dates or blanks. I want to be able to push a button (POST) and if column K has a date in it (ie. isn't blank) then today's date should be entered in column L (L9 down). Once this date is entered in...
  17. tlc53

    Multiple Password Linked to Combo Box

    Hi there, I currently have a Combo Box that when a name is selected from the dropdown option, a password is requested. If the correct password is entered (12345) the date will be entered in the corresponding cell. However, it is not quite working right. Currently it is one password for all. If...
  18. A

    Find text then Copy Adjacent Cell and Paste into two seperate cells

    Hello, just hoping to get some help with this. I’ve two words that have different values associated with them, I just want to findthe words and copy the values from the adjacent cells into separate cells for example Cell R43, R45, R47 etc for the value associated with Wait and a separate cell...
  19. A

    Copy (3) specific values from 375 worksheets, paste into another worksheet

    Hello, HELP! I am trying to write a vba script to copy three values from 375 worksheets and paste into another worksheet. All the 375 worksheets are in the same format, on each worksheet i need cell "G3" copied to Sheet12 cell "A4" , cell "C50" copied to Sheet12 cell "B4", cell "G50" copied...
  20. tlc53

    VBA Code Hide/Unhide Rows

    Hi, The sheet I am currently working on has numerous hide/unhide functions built into it. I am currently trying to to hide/unhide rows depending on the number of bank accounts selected. However, I haven't been able to get it to work at all! Can anyone see where I am going wrong? Private Sub...

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