integrate

  1. M

    How to create a Word report using Excel?

    Hi There, I am fairly new to this but I am trying to make a report in Word, I have a template that I am working from but I can't seem to find what I need online. Basically I want to be able to type details in excel such as company name, address, products, specific products used. I have started...
  2. M

    "Sort by" Formula

    Hi everyone, I am tring to integrate in my formula some data more to make an automatic order in the cell but I don't have no clue how to solve it.:confused: For example if I want to match two column with this formula =IF(ISERROR(VLOOKUP(C2,$A$2:$A$6,1,0)),"",C2), the result will be like this...
  3. M

    How to Integrate Client Data

    Hi, I am trying to integrate this, I have 1 client with their latest appointment on 1 row. How would I do this? <tbody> A B C D DOE, JOHN 02/14/2018 3 mos. 01/01/2018 DOE, JOHN 02/14/2018 3 mos. 05/01/2018 DOE, JOHN 02/14/2018 3 mos. 03/21/2018 A B C D DOE, JOHN...
  4. Vincent Thank You

    Last Row

    Hello, The following code is not allowing me to integrate the "lastrow" formula and is creating 0's well past the data range. On Error Resume Next With ActiveSheet.Range("N2:N2" & Cells(Rows.Count, 2).End(xlUp).Row).SpecialCells(xlCellTypeVisible) .Cells.FormulaR1C1 = "=RC[-2]"...
  5. E

    If contains than group under product

    Hi, For my work I get weekly data of specific product which I insert in my access database. I'm a self thought user so I learn by trial and error. However I have one problem. As example I insert the following in my database. 201713 - Product X - 24 201713 - Product Y - 33 201713 - Product Z...
  6. R

    Solver integration

    Hi Thanks in advance for your help I am using solver to build a feed formulation software where I can set min and max variable constraints and referencing that to the solver addin using code to least cost feed rations. My problem comes in when I try to use more then 300 or so constraints. It...
  7. S

    Integrating a Excel VBA Program into a website

    Hi There, I was wondering whether it is possible to integrate my program into an existing website so multiple people can access it online. Its a time & expenses program that is currently on a cloud system, which unfortunately allows multiple edits, and then end up with multiple versions. Any...

Some videos you may like

This Week's Hot Topics

  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • Highlight Row and Column on cell selection
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

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
Top