integration

  1. H

    Can you list Excel integration with other softwares?

    I'm making a list of the many Excel integrations with other softwares, like SAP, Salesforce etc. Thank you! :)
  2. P

    integrate value of cell A3 into formula

    Hello, I try to find a way to integrate A3 cell value into formula I got a folder full of invoices. File names are consecutive numbers starting with 180000.xlsx I want to extract for each file five differents cells. I'd like to manually write in colon A all file names without extension...
  3. M

    Adding a Formula to an Existing Formula

    Hello all, I have the following formula: =OFFSET(INDIRECT(ADDRESS(MATCH($F$2,'Portfolio - Integration (01)'!$D:$D,0),4,,,"Portfolio - Integration (01)"),TRUE),3,-1) It works perfectly and is part of a summary page of over 100 different tabs (bold to show that it directly references a name so...
  4. J

    Integration in Excel

    Is there any function or add-on available in Excel to do an integration calculation or to calculate the surface of an area under a graph?:confused:
  5. R

    Correct/Incorporation of a needed macro into existing code that adds an automatic hyperlink. Both triggered by same selection on a dropdown

    Hello: I need help in completing a macro and incorporating it into some existing code that does function as designed. It's close to working but I haven't been able to get it right. The 1st part of the code adds a hyperlink (and it works properly) see below The 2nd part is the problem, I'm...
  6. A

    Excel inventory integration

    hi everyone, i would like to ask this question, i am using excel for my inventory list which has the item sku and qty etc. but some items i do not keep them in stock, just i take it from my wholesaler when i get an order, but i need to have the qty of my wholesaler to see if i can rely on him...
  7. S

    Passing a function defined in a cell to a VBA function

    I have a numeric integration function using Simpson rule as follows: Function SimpsonInt(a As Double, b As Double, n As Integer) As Double 'This function calculates the area under the curve y(x) from 'x=a to x=b using Simpson's rule with n intervals ' 'Local variables Dim h As Double, sum As...
  8. H

    email integration and report gneration from a spreadsheet

    Hi folks. I'm investigating the possibilities of extending a spreadsheet I've been working on to manage data in a school. I've already completed the first stage of the process, creating the management system on a spreadsheet, but ideally I'd like to generate weekly reports of recent data from...
  9. V

    Map in Excel

    Here is what I want to do, I want data in excel to color a certain section on a map - how would I go about accomplishing this? I am pretty sure I will need to create an image map in order to create the particular coordinates.
  10. K

    Integration, Integrals, Calculus

    I am trying to take a pair of waveforms from an oscilloscope, specifically a voltage waveform and a current waveform, that was acquired from the same source. I want to then multiply the the waveforms together and integrate the resulting product. I want to plot this 'integrated product'...

Watch MrExcel Video

This Week's Hot Topics

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