integrate

  1. I

    VBA Code to Open Word Template and create new document per list of names

    Hello, I have somewhat of an advanced question... I have a long list of names in a column in excel (range name, "Names"), what I want to do is create a code that I can run that will open a template (named "CART") and based on the list of names the code would open a copy of the template and...
  2. T

    External Schedule integrate in to Excel

    Hallow everyone ! Guys how I can integrate Schedule Standard (STD) in my excel to automatically check 3 cells in my DB ? This is original pdf file of Schedule Standard This is my DB and I marked by color only that places which match with my DB, I want control those cells automatically...
  3. 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...
  4. 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...
  5. 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...
  6. 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]"...
  7. 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...
  8. 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...
  9. 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...

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