dynamic data

Apply page breakup as only page 1 to the dynamic data template and print it into PDF.

Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task to be conducted on weekly basis. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Television 3456 D Smartphone 7654 E Printer NA F Desktop 098 G Scanner NA...

Hi, I have to copy rows from one sheet to other in a same excel file. It's a repetitive task. Consider following example. Name Devices code A Desktop 234 B Laptop 2345 C Laptop 3456 D Smartphone 7654 E Printer 3456 F Desktop 098 G Scanner 123 H Laptop 65 I Smartphone 876 J...

I'm attempting to have PBI do some linear regression for me. From a helper query that iterates over multiple files, I'm calling this custom function to determine the highest reading above and lowest reading below the linear regression line over a variable length period for each row of data. It's...

Hi, I would love for some help in writing some VBA code such that it will scrape data from a given URL for betting sites, and will return the specific betting odd values as required within a sheet. I then want it so that these values can always be refreshed as required. For example: Using...

Hello geniuses, I am looking for a vba script that can set borders like the image here. The data can grow or shrink. And when it does, I want to adapt to it with the borders. I hope someone can fix it for me. Thanks in advance.

Hello All, I have powerpoint presentation and each slide has multiple shapes on it. Requirement is to update these shapes with values from excel sheet dynamically. Not all shapes are to be updated (ex. title, placeholders in footer etc). However, chart data, tables, few textboxes etc are to be...

Hello, Would truly appreciate if anyone can help me with this problem. Original data: Any help would be appreciated.

Hi, I have a table that updates as data is entered into another sheet. I want to find the mode of this data, but exclude the zeros, since there is a lot of zeros, because data has not been entered into the original sheet yet. Here is the formula currently being used...

Hi, I'm trying to create a macro that will work dynamically with the number of rows of data. To try and combat this I inserted a table to house the data, so that all of the references after would be more dynamic, but I've found myself stuck with the creation of the table, as it wants to use...

I previously had my worksheet set up with 80 Radio Buttons. My Radio Buttons are in the same cell as the target data. I knew using 'Offset' in the macro to copy and paste the data (my data is dynamic) in the cell would be better, but I couldn't figure out how to do that so I used a specific cell...

I have a worksheet with 4 separate tables, each with 20 rows of data. In each of the tables, I have 1 column for stock symbols, so 80 symbols total. The data comes into these columns via a live stock market feed so it is dynamic; the symbols move up and down the columns based on formulas from...

Is there a way to avoid having a LONG partially blank data calculation “helper” table that is filled with formulas? Any suggestions for creating a “dynamic” length calculation table that avoids the need for a table that is “formula heavy”? I have created a non-dynamic data computation table...

Hi - I am trying to fine-tune a scheduling spreadsheet for my company's 2014 work. We have projects organized by specific areas, with varying numbers of projects in each area. My goal is to organize the spreadsheet so i can select an area from a drop-down list in column A, which will...

How do i reference a cell range in vba when the range is dynamic? Basically I have a table underneath rows of data, at anytime data can be inserted into those rows. So everytime data is inserted my table shifts down a row and the cell reference in my vba code no longer match up. Is there a way...

HELP!! I am trying to create a dynamic BAR chart that changes with my data. The below is my data set which is dynamic as well. I've tried using OFFSET but i must be doing it wrong and need help ASAP if possible. I need to chart columns A, B, and C. Like i said, all 3 columns are dynamic...

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

Say I have an excel report that is an output from a web site. This excel sheet may have a different number of records arranged in a different order each time. I am trying to link sections of this data to individual PowerPoint slides. So in the example below I have a slide for AAA and another...