data table

i feel like i have done this a hundred times, but for whatever reason its not working for me... i have a data table that looks like this: <tbody> RATE Monthly 289.68 1.00% 262.81 2.00% 276.04 3.00% 289.68 4.00% 303.74 5.00% 318.20 6.00% 333.06 </tbody> all the RATE numbers...

So I have a basic investment analysis sheet that covers revenue, costs, pre-tax profit for 7 years and ends with an NPV that equates to an implicit margin. However I have been asked to create a two input data table to test the sensitivity of 2 variables in the project. I did that and have a...

Hi All I build about 20 odd reports in excel using an external data source(oracle database through an ODBC connection). At the time of build, the report connections were established in the Development environment of the Database. But now we want to pull data from the Production Environment...

Hello, I have a workbook in which a summary tab includes several 2-variable data tables. In my attempt to evaluate multiple scenarios, I have copied the sheets that include these data tables. In the copied sheets, there is a single value output for each data table (i.e., different years...

Ok so I have made a self populating Data Table to show me which employee is on what shift that updates daily from our roster. This works and it's brilliant, however I want to steam line my finished product further, but haven't been able to find an easy solution. I have several employees per...

The overflow issues has been posted about before but I can't solve it as it relates to my code. Could someone please help me print data to a table without any overflow/variable issues? Sub PrintDataTable() 'General variables Dim symCell Dim rngCell Dim dateVal Dim volVal Dim symbol As String...

Hi all, I have an Excel data table (called Products), which has a column called Name, which I use to populate a Data Validation drop-down/list. It wouldn't let me reference the column directly in the list, so I use a named range. This works fine, except that when the Products data table gets...

I have 4 columns of data with field names/column headers (people, office, case number, date). I have over 60,000 rows of data within those 4 columns. A single case number can have multiple people work on it over a given period of time in different offices (ex: John worked on case number 3 during...

[SOLVED: workaround found, see bottom] (Before you reply, I do understand that most decimal numbers can not be expressed exactly in binary format, even simple numbers such as .3. I'm trying to limit the number of digits after the decimal that are shown.) I'm trying to cleanup the data table...

Hello Friends I need to create a table after applying some logic to another data table. What is the best way to go about? I am not good with arrays but have feeling that I may have to go that way. if someone can guide then I'll try to find my way through. I wanted to post full detail of what I...

I have a workbook (wkbk1) that has a sheet with eight different tables on it. They all point to the same external Excel workbook (wkbk2) for their data. The data for each table comes from a named range. How can I copy the sheet of eight different tables (from wkbk1) to other workbooks (wkbk3...

Scenario:<o:p></o:p> I obtain a CSV file from the accounting system summarizing budget and expense amounts by project grant (i.e. departments) by G/L account. The problem is that it needs to be “cleaned-up” before I can utilize it as it is more like a report than a data table.<o:p></o:p>...

Hi all, I receive raw data and would like to manipulate it using VBA in an automated way so its in a format to be loaded into Access. There is three (or potentially more) tables of data on one worksheet (with 20 column headings of data and an unknown amount of rows), and just above every table...

I'm trying to use a sumifs formula to pull data from multiple tabs into one data table. One of my criteria is the name of the tab in my data set. However, I cannot seem to pull the data that I want to from the individual tabs. I have over 20,000 records divided by 16 tabs so I want to automate...

In a data table i have many columns and at the bottom I would like the last number displayed. so if i were to add data to it, ex 1-3 it would not change my LAST Row. But if I were to add data on 1-5 It would because jan 5th would then become my last input. Date |Item 1|Item 2|Item 3|Item 4|...

I am using a one variable data table to automate a complex calculation for three scenarios. The table doing the calculations is reasonably complex (a couple thousand array formulas), but calculates in a second or two for one scenario. When I try automating the calculation of all three...

Discount = 30% B 9.48 A 0.67 B 0.59 A 3.66 B 9.07 A 2.65 I am trying to make a Data Table that changes the Discount % (10 - 100) and finds the Minimum amongst A. With every change in Discount, the Values of A and B changes, and some Bs can become As and so on. They are linked to an Equation...

Hi, Can anyone help me out with a code on how to refresh a data table via vba. My workbook has been set to automatic recalculation(except data tables) due to speed issues. I need to have a macro that I can call whenever I want the data table refreshed. Please help me out.

I have a macro set to run every time cell B6 changes (specifically, the macro uses "On.Entry" to run a Goal Seek every time B6 changes). I also have a data table with B6 as the "input" cell. But the data table outputs do not reflect the Goal Seek results of the macro that would run if cell B6...

Here's my starting data: <TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR...