dynamic table

I'm new to excel Table. I wonder if it is possible to make a Table to be auto-updated when size of another Table changes? Here is my case below, please see in screenshot (I make it simplified for this question). Excel file is uploaded here: Dynamic Table I have 3 Tables: Properties, ElementA...

I want to make the bellow table dynamic with the following options: A dropdown list that contains many products (product 1, 2, ...etc). A dynamic calendar cell that enables me to choose any date. Link the date cell and the product cell to the whole table so that when I move between products or...

Hi all, As recommended in another post, I converted my macros into a table-based Excel which includes queries. I am now facing a issue that I hope somebody can help with. I am trying to create a table that has both columns and rows dynamically updated. I managed to do this, but the content of...

Hello, I use a dynamic table which absorbs data from a query regarding the name of sales agents, names and codes of (their) clients, and hours left from a pack. It can be updated to reflect the new amount of hours left, and I can filter by name of salesperson to show only their clients and the...

Column A is return of formula. Column B is Alphabetically sort number of Column A. I need a Dynamic table that in Table Column1, put sort numbers from 1 to how much is that from column B. and if Column b Updated, it update too. IJKLMNOPQRSTU12Column BColumn A316Apple...

Hi all, I am trying to perform an auto-sort of a table using VB, where the table is dynamic using formulae rather than hard-coded data that is static. The table range is J3:R7 with row 3 being the table headers. When data is input, I need the table to update and sort based on the the updated...

Hi All, I have two datasets which can vary in length: Employee (column A), and Funding Source (Column B) I would like to create a table (in columns F and G) which will generate all possible combinations of Column A and Column B. Ideally, this table would be sorted by column F, and then by Column...

Good day experts, I have great need for a formula that outputs either TRUE/FALSE based on some criteria, the sample table is as follows: <tbody> (A1)EMP ID HRS WEEKDAY OUTPUT 0001 9 1 FALSE 0001 9 2 TRUE 0001 9 3 TRUE 0001 9 4 TRUE(D5) 0001 6 5 FALSE 0002 6 1 FALSE 0002 7 3 NOT...

Hi, I have a table with 1000 records. Only approx. 10% of them however have some TRUE condition. <tbody> Name Condition A TRUE B FALSE C FALSE D FALSE E FALSE F TRUE ... ... </tbody> I would like to create a table on another sheet that shows list of names, but only for those...

I would like to create a table with an unknown range. I currently have the following. Sub Button2_Click() Dim r As Range Set r = Worksheets("Sheet2").Range("A1").CurrentRegion Worksheets("Sheet2").ListObjects.Add(xlSrcRange, Range("A1:B4"), xlYes).Name = "MyTable" End Sub An...

Hi, I recorded a macro, and everything is working perfectly, except one thing! I have several sheets in a workbook that have data in columns A:P. The number of rows with data will vary each time that I run this macro. So, I might run it today with data in Sheet1 from A1:P100, but tomorrow...

Hello, I have 2 data tables that get updated and carried forward every month. I have another tab that essentially has each table stacked on top of each other 8 times, with formulas and links to the data tables. When I insert new rows to the data tables, I would like the rows automatically...

Hey guys, I'm currently trying to figure out a problem and I'm at my wit's end. Hopefully somebody here can help. On one of my worksheets I have a Pivot Table filled with values from a dataset (from SQL query). It looks a little like this - <tbody> Batch AH CB CH CO 3936875 40 0 0 0...

To Whoever Can Help, I wrote some code in or to create a dynamic graph that uses the attached template sheet. However, i continually get an error message that pop ups whenever data is added or deleted. It is asking to verify the formulas are correct, which i know they are since everything still...

I'm currently trying to make column of lists (starting in D2 and going well into the D500's) that are dependent on a list in the corresponding C column. So for example: A___B___C (1st list)_____D (list dependent on 1st list) ... __...____ Supplies____ Erasers ... __...____ Supplies____ Pencils...

I have the below macro that applies text to row working fine. However the line in red is not working. I essentially want to fill down the formula instead of the values, as in all of the other columns. Any help would be appreciated! Sub Workbook_Open() ActiveWorkbook.RefreshAll...

Hi All, I am working on a dynamic spreadsheet sucking information from our company CRM platform (Microsoft Dynamics). Column B details facility number, which ranges between 2 - 4 numbers, however there may be 2 facilities to the same client (and row) as illustrated below: <tbody> 10/09/2008...

hi, in sheet1 I have source table: <tbody> Car Year Color Type Audi 2000 Red Sport BMW 2001 Black Coupe Volvo 1998 Yellow Combi VW 1996 Black - Fiat 2003 Red Family </tbody> Then in sheet2 in A1 I will be selecting car name (Audi, BMW etc). Now if I choose "Audi" I want to in...

I was looking for an answer to an Excel web query issue, and found a pseudo solution on an older thread (linked in trackback). The issue I'm having is retrieving data from an Excel web query, where the data on the web is dynamically obtained after the page has loaded. The result is an empty...

Hello, I have tried the search engine and I don't think I have worded my issue correctly. Pardon my English as it is not my first language. I'll explain what I have and what I need. What I have. 1. I have a workbook where it contains several sheets. 2. The first sheet will contain results...