vba

  1. K

    How to trace 2 Digit And Highlight Cell , Different Number to change Different Color Highlight. ?

    Query : How Set Different Number to Different color Highlight (like a same number Group Show in same color) Number match perfect & Smart..........pleased Solve it Conditional...
  2. D

    Pivot table solution? Please help!

    Hello everybody, I am currently managing a list of materials for different sections: The top of the list looks like this: I have about 6 sections (EM, Formulering, Inspektion & more - please let me know if you want all the names). I want to create some sort of pivot table (I assume? I...
  3. K

    How to lock image in excel cell in VBA ?

    Solve this query....
  4. C

    Copy and Replace Excel Table to PowerPoint Table data

    Hi Everyone, I have an Excel Sheet which contains a range of values as Table, I want to copy those values and replace them in the PowerPoint table(which is the same range as source table). My slide may contain one or more tables so I will identify them using table name, Below is the code which...
  5. I

    Print to PDF - Fit to 1 page wide + automate saved file name

    Hi Everyone, I am very new to VBA and need some help please. I have 2 work sheets which I want both to be saved into the 1 PDF. I can get this working with the following piece of code however I face 2 issues: 1) I can't seem to get it to fit to 1 page wide (I get only left half of worksheet in...
  6. B

    If tab for sub has nothing, call the next sub VBA

    Hi Everyone, The title says it all. Basically if my "A2" is empty I would like the vba to immediately call the next sub procedure. What's the best way to do this? I would write it in every sub for efficiency purposes.
  7. I

    Copy content from 2 worksheets to 1 and remove formatting

    Hi Everyone, I could really use some help - been on this for a few days now. I am no expert at VBA but learning as I go and normally solve things on my own. Is there a way to; Create a new worksheet and name it "Print Summary" Copy content from ActiveSheet to "Print Summary" (preserving...
  8. J

    VBA filtering array

    Hi All I'm looking to filter with the criteria being an array - can't quite get it to work. Simple example below - where am I going wrong? Thanks in advance! Jon Sub test() Dim Narrative As Variant Narrative = Array("*OPENING*", "*CLOSING*", "*VALUE*") Range("A2:H100").AutoFilter FIELD:=4...
  9. M

    Automatically Printing Autofilters / loop through all filter values then print vba

    Hello, I need macro or VBA code to print all data in the table based on # column like filter 1 then print then filter 2 and print etc can anyone help, please
  10. P

    Create a choice field in Sharepoint list using VBA

    Hi all, I have developed a tool which creates a new list in sharepoint when I run a macro. But its takes datatypes of column only as 1) Single line of text 2) Number 3) Date But I have a column in excel which has a drop down options but after running he marco, when I check my sharepoint list...
  11. D

    Conditionally format cells to red color if cell 4 rows to the left is not blank

    Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...
  12. C

    VBA - Copy worksheets and rename automatically in another workbook

    Hi, I encounter a problem and not sure how to continue from here. What i would like to do is: First, Copy sheet 1 from all the worksheets into this new workbook where i have my macro run. (this i have no issue, here is the code) Next, as I copy these sheets from their respective workbooks, I...
  13. J

    VBA Copy and Paste Data from one workbook to another - specific columns

    Hi, I have a statement converted from pdf to excel. Unfortunately, the column headers above the data that I really need may lie on different rows, for e.g. row 17 or row 18. I have 3 columns I want to copy from the statement: Date (column B), Description (column C) and Amount (column D); then...
  14. D

    Vlookup to return Multiple values

    Hello Excel Users, I have a spreadsheet with multiple tabs where the first tab has unique numbers and the other tabs has the the unique numbers with multiple values associated to it. I need to have the first tab return the multiple values from the second tab. Column B in the first tab is what i...
  15. R

    Assigning a variable to a databodyrange?

    I'm using PowerQuery to produce a table containing one column of email addresses. I want these email addresses to be my distribution list in an email. I'm using VBA to create an email window with the addresses already populated. Originally, I was using a loop to cycle through the column of...
  16. J

    Convert PDF to Excel and Copy into existing excel sheet

    Hi, I want to convert a pdf file to excel and be able to transfer the data into another workbook using VBA. Based on research, converting pdf to excel can be done by first converting to Word document and then to excel. But I want to know if the excel conversion can be transferred into an...
  17. montecarlo2012

    [vba]. read values in color only on vba.

    Hi everyone. How to read only the values with colors in a column and display this values in a row in another sheet, small example don't need xl2BB I think, so couple images can show my point. this is what I have on sheet2 and this is the results I am expecting on sheet3 Please, Can anyone tell...
  18. K

    Charts changing section colors with slicers

    Hello! I have an interesting problem that I am occurring. I have created some charts that is looking at racial data through pivots. When using some slicers to within the data that I have, it takes away some of the racial information that is located. You can see with the images below. While...
  19. Q

    Compile Error for defining a function in VBA

    macroTest1 runs fine when the entire function is commented, but this error comes when I comment the function I am using the following references can someone help me with it?
  20. T

    Running graph-creating macro through multiple rows

    Hey, I dont and cant use VBA nor any other programming language at all but need this thing for my work, so sorry in advance for my phrasing; I created a macro simply through "record macro" button in excel. The pourpose of it is to create a simple graph out of one row of a table. Now I need...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top