data table

  1. S

    Pulling list of Unique Names from Refresh-able Table between Date Range (Or Month Number)

    Hello! Thanks for any help in advance: I'm attempting to create a "dynamic invoice" of sorts, with names being pulled from a "refresh-able" table. By that term, I mean an excel table that (I'm assuming) is pulling from an SQL query and just needs the "refresh all" button on the Data tab to be...
  2. J

    Data Tables & Goal Seeker

    Hi All, First time poster here and looking for help on what I believe may lie with data tables / goal seek. My spreadsheet currently has many formulas but can be simplified to: Margin = (Price - Costs) / Price I am looking to answer a question: ‘What would my price have to be if costs...
  3. S

    Pivot Table Help - Is this even possible???

    I have a large data set and I am hoping to create a pivot table off of it. My concern is that I don't think it is possible to do how I am envisioning it. I keep getting a big red "X" and denied sound in my head when I think about how to create this pivot table. My data table has multiple...
  4. T

    Data Table - 3 row input cells

    Hello All, I have a scenario I want to run where I am doing three different improvements to a property, each of which are increasing returns. I want to show the returns assuming none of the improvements are done. I have figured out how to show it given one variable {=TABLE(#UnitsReno...
  5. R

    Store and Call Data in a Macro

    Hi all...I have a bunch of data in a table, and I am trying to write a custom function to call that data based on the function inputs. Here is an example of the data: <tbody> </tbody> <tbody> Motor HP RPM Alpha Beta Gamma EE 5 3600 .93 .03 .30 EE 7.5 3600 .98 .1 .2 EE 10 3600 .86 .25...
  6. R

    Problem in working with Data tables in Excel 2016

    Hello, i am facing a peculiar problem. I was doing a sensitivity analysis through data table and putting the IRR value as a reference for the data table to calculate values. For this I am using the cell reference of the cell in which I have calculated the IRR value of the project. And...
  7. T

    Loop Updates

    Hi All, I am looking to use a loop to update a name within a cell if that name changes and this is the logic behind how i see this working. E.g. Sheet 1 cell E4 = New name Sheet 1 cell M45 = Old Name then if New name <> old name Find old name in sheet 2 (column b, data...
  8. P

    Using VBA to enter data into a cell

    Can I use VBA to write a code that would take a data set on one worksheet and enter one of the values into a formula cell on another worksheet - then takes the output of the formula cell and pastes it onto another worksheet - Repeat this process down the data set. Not sure if that makes senses...
  9. T

    Data table with different data input

    I have created a data table used to show contribution margins at different fee levels. The numbers for the contribution margin calculation comes from different worksheets depending on the choice you make in a drop-down menu. I have the correct calculations in my data table, but when I choose...
  10. A

    Monthly Timesheet Tracking With Multiple Jobs a Day - Dropdown Question

    Hi Everybody! I'm trying to create a spreadsheet for tracking time information. I've gotten what I think is a good start by using this template ( https://trumpexcel.com/excel-timesheet-calculator-template/) and flowing the information to a pivot table. Right now my entry areas hold a month's...
  11. J

    4- way Data Table

    Hi, I’m looking to create a data table that involves 4 variables. The input variables are: Platinum, Palladium, Rhodium & USD/ZAR. The output is a financial metric EV/EBITDA. I can create two way data tables, but I want to create a data table with all variables included. Is that possible?
  12. B

    Multiple Date Trouble

    Hey All, I have two data tables linked by Sale number. Let's say the data looks like this: <tbody> Sale Number Sale Date 12345 01/01/2016 23456 02/02/2016 34567 03/03/2016 45678 04/04/2016 </tbody> <tbody> Sale Number Change Date 12345 01/02/2016 12345 01/08/2016 12345...
  13. E

    Design suggestions for dynamic data table design for portfolio evaluation model

    Hello All, I'm developing a tool to be used as a weighted-average portfolio evaluation scorecard on which I could use some design advice. I've enclosed screen captures [will upload later] of a sample model that illustrates the tool design. Overview: I have a data entry worksheet and multiple...
  14. C

    Count "All" occurrences of a category from a drop down list

    Good morning I have previously received some great assistance for a problem I had using the Countifs function from Joris, a board regular. I wish to expand on this formula to be able to achieve a new level of functionality for a project I'm working on. I currently have the below data on one...
  15. N

    Data Table Refresh Button

    I'm working on creating some data tables in an excel worksheet. I know that pressing F9 can refresh data tables but other people are going to be using this sheet and I am trying to make it as simple and obvious as possible that the data tables will need to be refreshed. I'd like to put a button...
  16. K

    Excel VBA Scraping IMAGES from an HTML 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...
  17. R

    Data table not calculating second variable

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

    Conditional Formatting in a Data Table

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

    Adding a secondary vertical axis without impacting data table as horizontal axis

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

    Macro Help

    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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top