excel & vba 2010

  1. V

    Index match formula not matching properly.

    I started with a vlookup but moved to an index match. I am trying to match two columns 1 column has an ID in it the other column has a ^ with an ID. If I put the formula of the cells I get a match but when I use the index match it won't match. I am comparing value from one sheet with values from...
    • vba317
    • Thread
    • excel excel & lookup & search excel & match & replace excel & vba 2010
    • Replies: 2
    • Forum: Excel Questions
  2. S

    Last row two times.

    Hello, This code works but: After removing duplicates in column "A", I get a new last row in column "A" so I must "declaire" "lrow" again so dates in column "B" are not filled in to the first "lrow". Is there a way around this? Sub Start() Dim ws As Worksheet Dim lrow As Long Set ws =...
  3. S

    Delete duplicates but Not delete entire row

    Hello, I have searched and tried a lot but can't find the right answer. Headers in row 7. Data range= ("A8": last cell in column "Q") Column "A"= Names Column "B"= Dates Code deletes rows with: duplicates in column"A" and oldest dates in column "B". Code is working fine but it deletes the...
  4. K

    Error: Object doesn't support this property or method

    Hi Excellers, I am trying to fetch my email data into excel. Some how I find the code from net but facing the error like object doesn't support. I investigate and got to know might be its just because of access of multiple accounts. Could you please help me with this: Below is the code...
  5. A

    Search Box in Excel

    <body id="cke_pastebin" style="position: ********* ***** **** ******* **** ******** **** ********** ******* ****** -100****"> <tbody style="margin: **** padding: **** border: ****"> -3down votefavorite I would like to add a search box to worksheet 1 in my workbook of 2 sheets. Table with data...
  6. J

    Dynamic Named Range and MIN Across Multiple Worksheets?

    I have an Excel 2010 workbook with a separate worksheet for each month. The sheets are named with the abbreviated month name and the year (Jan 2016, Feb 2016, etc.). I need to create a dynamic named range that includes K1:K34 for only the current month through December (so right now it would...
  7. E

    VBA Error on Exit Sub

    Hello, I have several macros configured to pull data into a worksheet. They both function correctly until the very end of the code, when I get an error on Exit Sub. This error is "Code execution has been interrupted". This does not occur every time the macro is run, and if I run it under the...
  8. E

    How to save each row in an Excel table as an individual .CSV file

    I am currently trying to automate the process of saving each row in an Excel file as an individual .csv file. I was able to record the below code when doing it manually for 1 row and would like to automate this for all rows. I'm hoping someone might be able to point me in the right direction...
  9. N

    Time format for userform and spreadsheet

    I have a userform (Userform1) that has a textbox (TextBox2) that is a time field ideally formatted to hh/mm am/pm. It is stored in a sheet (“Schedule”) in ColumnB. I need to format both the data in the sheet and the userform. I have a function that when the user clicks a button, the data from...
  10. E

    Show Range of Cells based on Cell value (multiple cell values or buttons) – Excel VBA

    <tbody> I want to display/show columns based on cell values or button commands – VBA Eg : I am trying to compare monthly sales values for the period Jan to Dec via VBA Code, I want to show only two columns (range of columns) for two months which I am comparing among 12 months. So if I...
  11. B

    How To Copy A Row using VBA

    Hi Guys, I was just wondering if anyone knows how to copy Row 8 From Sheet 1 to A1 in All Sheets in the workd book. Many thanks Jamie
  12. B

    Macro that finds Names and DOB over 2 Workbooks

    Hi Guys, I've hit a brick wall... I need help making a macro button in WB1 to open WB2, then to find and match a customers information (First Name, Last Name and DOB) and then mark each match as a "YES" or as "Blank" after the last cell on WB1 Here's an example of the workbooks. WB1...
  13. K

    Run-time error '1004': Application-defined or object-defined error with Workbook.Open

    I have a workbook with multiple tables as depicted in the following image: I am trying to write a procedure to loop through the list of system names and ask the user a series of questions. First asks the user: Are there scan files to read? It then asks the user: Is there a scan file for the...
  14. A

    Excel VBA - Evaluate MIN with two criteria not working

    I am currently writing a piece of code, that finds the first date of something for two categories, in the cells. If one of the cells has a date filled in, it ignores it but if the other cell is blank it runs the evaluate formula. The problem I am having is the code formula works on the sheet...
    • atame
    • Thread
    • excal vba excel & vba 2010 excel 2010 vba
    • Replies: 0
    • Forum: Excel Questions
  15. V

    How to change and print multiple filters of a single pivot table at once?

    Overview: I have a pivottable with filter. The filter contains a list from 1 to 30, each of which must be printed separately. That is, each time I have to change the filter and print the filtered result. My demand: What I want is to print all of them at once. Conditions: The list of...
  16. G

    Merge Multiple workbooks into one workbook

    Hi All, I found this code online. For the most part it works to what I want it to do. But there are a couple of issues. 1 - I would like to add code where I can open a window to select where all the multiple files are located not just hardcoded. 2 - The line of code where I asking to...
  17. P

    Freezing a Combo Box to a specific location on the Spreadsheet

    Group, I've got multiple combo boxes spread out within a single worksheet. These will hide and unhide by section as check boxes are checked and un-checked. I need to ensure these combo boxes remain in their "assigned" locations as the rows hide and unhide with the changes of the check boxes...
  18. V

    Runtime error 9 subscript out of range

    I am trying to open up an CSV file in a text delimited format. The file processes alright but when my routine returns to where it came from I get a runtime error 9 on line Set wrkbkOrig = Workbooks(sPracticeSelected). Any help is appreciated. [code] 'To open a csv file If...
  19. V

    Trying to convert a string to integer getting error 13

    I am trying to convert a string to an integer and I am getting an error 13 type mismatch. I am getting the error on the lNewColumn = CStr(sCol) line. I am inserting a new column in the spreadsheet. Than I am cutting another column into the newly inserted column. Finally I am trying to delete the...
  20. V

    Trying to do vloopup in VBA getting a #value error

    I am trying to do a vlookup in VBA and I am getting an #VALUE error. I am trying to match values in column A of a sheet called data with the values from column B on a sheet called Default Pt List. On a match I want the value to go in Column H of the sheet called data. Any help is appreciated...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top