dynamic tables

Hi Folks, I'm trying to format my dynamic excel table, so that IF text in a cell in column A is colored white, then the entire row--within the table boundary only---will have Interior.ColorIndex = 25. The only code I've managed to use to successfully change a row within a table to a different...

Hi everyone, I'm trying to get a file formated automatically. This file is extracted from another program every week or so. In the image below, you can see an example of what I want to achieve. At the top, you see how the data is initially formated, and below how I want it to be. I've created a...

Hi all, First time poster, so excuse me if I've made a mistake anywhere. I would like to pull house price data from imot.bg. The normal Excel web query doesn't work because the table is created dynamically (javascript). I would like to automate the process if possible because each table...

Hi all, I am looking to create a new table in my Excel 2010 workbook which dynamically populates with data from the other sheets within the workbook based on a certain criteria. To cut a long story short, across various sheets are a huge number of different products which are being bought and...

Hello, I am basically trying to do what is shown in this video. I want to do almost the exact thing except that all the files 538, series1, series2, series3 are in separate workbooks (4 different workbooks). I have tried changing the parts of the formula that make reference to the 538 tab...

I am having a huge amount of trouble with calculated columns, and errors with them when adding new rows to a table. I am trying to maintain a list of sales while dynamically maintaining a list of unique customers who make purchases. I am using a helper column that counts new customers are they...

Hello Forum Readers, This maybe a tough one. I want to stack tables with a blank row between each table and make them dynamic using offset based on the position from the top row. So when a row is added to PR.1, the row between stays and the other tables shift down by the number of rows...

Hello - I am working with some dynamic tables. I have named the ranges and graphed them. I am naming the axis with the table name and it is working beautifully: for example: Axis label Range= ='SheetName'!TableName However - I need to make several versions of these and the tables need to...