excel vba

  1. J

    Pulling data into a table based on date and number criteria

    Hi Guys, I have a list of raw data on a separate tab to the table which consists of two columns, dates and the second column holds a number between 1 and 5. What I want is for the table to pull data from the raw data so that everything it counts how many of each number between 1-5 there are...
  2. X

    Filter the highest sales and show the whole row of highest sales

    Filter the highest and lowest, open a new workbook and copy the data to a new workbook and save. Sub FilterData() Dim HighestSales As Long Dim LowestSales As Long Range("A16").Value = "Lowest Sales Data" Set Rng = Range("P3:P7") Set LowestSales = WorksheetFunction.Min(Rng)...
  3. mehidy1437

    MsgBox appearing thrice in VBA?

    Hi Guys, I'm working on below code, end result is okay, but I'm getting the MsgBox thrice. After editing the cell when I press enter its giving the msg & have to press ok/enter another two times to deactivate the msg. This code is running on "Worksheet" with change event. Need your help to...
  4. P

    How to set date range in VBA coding to extract SAP reports

    I'm a newbie to excel VBA coding. I used script recording but I'm not sure how to setup date range from current date to 2 months intervals to extract report from SAP. Kindly assist - Thanks! Dim SapGuiAuto As Variant Dim SAPApp As Variant Dim SAPCon As Variant Dim session As Variant...
  5. K

    Updating an inventory using User Form

    Hello everyone, I am very new to VBA and I came accross this question for which I couldn't find an answer even after browsing the internet for hours. So, any help from experts like you all is highly appreciated. I have two data sheets as Service Registry and Inhouse Inventory. There is a...
  6. S

    [SOLUTION HELP]: Copy data from cell and pivot table into new table format.

    Hello, I need your help on EXCEL VBA solutions as per below requirements 1. Copy pivot table data in cell A9:A11 and C9:C11 in to sheet OUTPUT per example in sheet output. 2. Copy data from sheet INPUT cell G32,G36,G37,K32 (cut only first 2 digits),K33,K34,K35 (cut only first 3...
  7. J

    How to copy date from excel to word

    Hi, I have the below code which opens a word document and find words in column A and replaces it with the text in the adjacent cell in Column B. This works well. My issue is that when it copies a date from one of the cells to word, it displays the date as a number rather than a date. Public...
  8. S

    Use VBA to generate SQL reports

    Hi I need help in writing a vba code which would connect to SQL and run a SQL statement to generate a report based on company name. The code should then save the output to the defined location in the excel data table The data table in excel has company names from b2:b50. Column C is a user...
  9. S

    Comparison between two data tables

    Hi I need a vba code which could compare 2 worksheets which has data in different sort order The data tables have no primary key and I need help in identifying how this can be compared to identify differences by reducing manual effort Once the data is compared between 2 worksheets, the code...
  10. S

    List all Open Workbooks in Combobox

    Hi I am trying to create a userform in a MASTER workbook where I want help in listing all Open workbooks including CSV files listed in a Userform combo box. This combobox should include all open workbooks including the ones which are not saved in the local drive. The master WB should be...
  11. G

    excel vba find option

    hi i have a written a macro to search and find set of variables from one sheet( here give as reportsheet) with another (datasheet) and copy value next to it. search works fine if all the search items are in datasheet but if something is not available i want reportsheet cell(k,5)to have value...
  12. A

    Several issues with userform macro

    Hi Guys, I have a few issues with a userform. It used to work fine but after I made a few changes it stopped working. When you fill out the form it should open 2 emails ans display them before sending them to make sure they have the necessary attachments but it only displays the second email...
  13. S

    Excel VBA to cross match 2 sheets data and output into sheet3

    Hi Friends, Trying to match 2 sheets data and copy entire rows into sheet3 I been through posts on this mrexcel forum and on google search but did not find a correct vba to do the task. In sheet1 ColumnB is always blank In sheet2 ColumnE is always blank I manually copied what results should...
  14. E

    How to copy values from one workbook sheet to another, based on criterias ?

    <button title="This question does not show any research effort; it is unclear or not useful" class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" aria-pressed="false" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image...
  15. P

    Web scrapping with JAVA based website

    Hello all, current issue is that i am working on one website where it run JAVA script to load data and i need to copy that data once it complete loading. now loading time is not fixed so my code run before it completes loading. do some event and readystate=4 is not working on this. is there...
  16. E

    How to connect INDEX MATCH formula with FILE open Dialog ?

    I have this formula: =INDEX(Tabelle1!$D:$G;MATCH(1;(Tabelle1!$F:$F=A9)*(Tabelle1!$D:$D=E$1)*(Tabelle1!$B:$B="Motor");0);4) which works perfectly fine. What I want is to create a VBA Code that does the same function as INDEX MATCH just between the worksheet I Need to connected with different...
  17. tlc53

    VBA Code - Error on Code - Where am I going wrong?

    Hi, Can anyone please tell me what is wrong with my code below? It highlights the 3rd to last row, Me.CommandButton2.Visible = CBool(Target.Value = "YES") It says Run-time error '13': Type Mismatch Thank you! Private Sub Worksheet_Change(ByVal Target As Range) If Not...
  18. D

    Microsoft Print to PDF Suppress "printing" Dialogue

    Hi, I wonder if anyone knows how to do this? I would really appreciate some help. I did find something i think is the answer but it is very old and i have no idea how to use it. I have a macro that runs through an excel sheet, reads an address of otehr workbooks from hyperlinks in column A...
  19. V

    How do I drag excel Table data to right dynamically using vba code

    Hello Expertise, I want to write VBA code for dragging excel Table range data dynamically to Right side column wise as per given date. For eg. If I give Date for "Sep-19" in Worksheet it should automatically drag the table range to right containing Sept-19 data. I am Excel 2016 version. Below...
  20. S

    Login to Shared Folder Via IP Address

    Dear Friends, i am learning VBA and went to several websites and forums and with the help of those i have created a small tool in excel. where it gets collated multiple sheets into one, as of i have mapped the drive and its working file however now i want any one can do this exercise and its...

Some videos you may like

This Week's Hot Topics

Top