data table

I have an HTML data table on a website, and have set up a code to scrape all of the data from it. HOWEVER, it does not scrape the images in this HTML data table. I want to scrape the images and have them go in their associated column of their associated rows. If I cannot scrape the images, it...

Hi all My Data Tables seem to be ignoring the second variable, and only calculating column inputs. I'm trying to do a What If analysis to see how projected income will vary dependant on revenue growth percentage and EBIT margins. The Data Tables are all calculating the growth percentage...

I have created a table by keying in some row headings, some column headings and some data, then doing Home, Styles, Format as a table. Over the last few weeks I have added more rows and columns. I few days ago, I added some conditional formating to columns N, O and P. Then I added a few more...

Hello, I am struggling with this one. I have a stacked bar chart to which I have added a data table beneath the chart. Normally, when I change the primary horizontal axis to display as text, it disappears and pulls the data table tight against the bottom of the chart so that the column headers...

Is there any way to insert data from a filtered data table into a form created on another worksheet with a macro? In other words, I would like to filter a data table, and then click a button that will transfer only the data on the filtered table to a form on another worksheet. Thanks

I have a macro that advance filters some data according to a criteria range, and then places the desired fields in a data table on another worksheet. The advanced filter code is straight forward and works fine, but I notice that unlike when I simply copy and paste data into a data table, in...

Hello, I'm admittedly not an expert when it comes to excel charts. What I have here is a small data set comparing average fees per account for four different mutual funds. I have that charted off to the right, but in the data table below, I just want to show the % change. I'm just trying to...

The basic setup is that I have an Excel file with multiple sheets, each of these sheets has a data table. These data tables (lets singular-ize them and call it Table_Data for the example) list a Date (numeric), Description (text), Category (text), Value (numeric), and a other pieces of...

Data-table calculations seem to be the perfect target for multithreaded calculations. In my tests though, Excel caps out at 12.5% CPU on my 8 core machine. Am I doing something wrong? Are data-tables really not MTC compatible? Any technical reason they shouldn't be?

Hi, I've created a macro that applies filter criteria to two Excel data tables on the same sheet. In the row immediately following each of the data tables, there is a row which contains Subtotal functions. The subtotal row (below the data table) is formatted with a double-line border along the...

Background: I have been working on a pretty typical financial model that requires a circular reference (i.e. the amount of debt for a project is dependent on total project cost, which is dependent on the amount of debt, etc.). So I have turned on iterative calculation to handle this. The...

Hi, I have a chart with data table and 6 data series: target1, data1, target2, data2, data3, data4 (for 4 months) target1 and target2 should be linear graph, data1-data4 should be column/clustered column graph. I'd like the data table to show these series in order: target1 data1 target2...

Good morning, I am trying to invent a formula, that in a single calculation (withoutadding two calculations) will allow me to count all "currentemployees" from "employees" table. I have a data table"Employees" with a column "Work To" which is: usually empty (for current employees not on...

Hi all! I doubt if this is possible, but I was hoping that I could use the data table functionality in Excel to calculate the sum of a large number of outcomes for me without needing to list them. I think it's best to explain with an example. So, I make a formula: <tbody> x 2 f(x) = x^2 4...

Since weeks I am looking for an add in for table valued function but I couldn't find any... Could you recommend me some add ins that can help me to make operation with excel tables?

I have an array of conditional statements that changes every time I select a new category using a list box. I would like to use the indices of the true (=1) values in the array to populate a data table (so the size will change every time I select a new category in the list box). How to...

Dear Sirs, I wander Whether it is possible to track history of data connection output results without VBA. For example, there is daily updated table in the internet in the format {date;value} It was loaded into Excel Data Table with help of web query. Each day on update of table old data...

I have a large table that I want to reconstruct. For simplicity sake, let's just says it's 3 rows (excluding headers) by 3 columns. <tbody> Item Description 1/1/2014 1/2/2014 1/3/2014 Cheese Burgers 2 3 4 Hot Dogs 5 12 6 Beverages 2 5 3 </tbody> I want to reconstruct it so that the...

So I've been looking around and haven't quite found the formula that I am looking for. What I would like to learn how to do is:take a cell and look for that number on another sheet and post the unit price and product description accordingly on the first sheet.

Trying to fix this formula to remove the showing of: "#DIV/0!" but not having luck.... =((K88*K93)+(K89*K94)+(K90*K95)+(K91*K96))/(K88+K89+K90+K91) Ultimately, this is occuring in YTD (yr to date) tables that are awaiting input for future months that have not taken place yet.... These #DIVS...