integration

Hi, I need to get data from Amazon and eBay and have it in my Excel Sales dashboard. I need to have it refreshed without additional files etc. Is it possible to connect there? Thank you for your suggestions. Maciek

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

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...

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...

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:

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...

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...

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...

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...

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.

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'...