dynamic cell references

Hello Excel Gurus, I am seeking some help writing this code to create multiple pivot tables from - multiple data-sets that are on one worksheet. So my data-set is exported from a website, and it goes from Range "A1:L-infity". My Data-set is dynamic so the range changes when I export it...

I have a table with two columns - both columns have cell references. These columns produce a summary table. The first column scans a row of data and only returns a list of unique values. There are over 500 rows of data, and my formula returns a maximum of 18 unique values. Sometimes the data...

I'm new to using VBA in Excel, so my apologies if I am not explaining this well. I have created a complex spreadsheet with a number of worksheets. I have multiple instances (dozens) of cells that update each other in both directions, i.e. if data is entered in worksheet 1 cell B1, worksheet 2...

I'm looking to reference a table column for my chart data, =Workbook1.xlsx!Table1[Values] If possible it would be even better to be able to dynamically change the table name using the INDIRECT formula: =INDIRECT("Workbook1.xlsx!Table"&$A$1&"[Values]") where A1=1/2/3/etc. Currently the only...

Hello, I'm attempting to put a dynamic calculation within an workbook that will calculate the year to date change (in percentage or nominal, either or), in the data set that changes as new data is appended to the end of the column. I have found some formulas that will return the value of the...

I have a sheet with Group Name and Group ID, under which I have Sub ID numbers and Sub names. On another sheet I want to select the Group Name to get the list of Sub Names populated in a column. For example: <colgroup><col><col span="2"><col><col></colgroup><tbody> Bob's Family 1289731...

I come here to ask for some help from my VBA expert's friends. I have about 150 .xls files where I have the measurements of the buildings where I've worked in and I need the data of these 150 workbooks in a single main file where I have monthly measurements with a general report and charts...

Hi all. I can't begin to express how magnificently helpful this site has been to me over the years. Until now I have always been able to find solutions to my problems through experimentation and diligent searching. At long last, though, it has come to this: a direct plea for help. I am...

<TABLE style="WIDTH: 392pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=522><COLGROUP><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 768" width=21><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 11pt...

Hello All, I am trying to figure out how to get this spreadsheet to wrok the way I need it to. I insert the "Green" portion below from "NotePad". It is always in this order and format. I need to track and total when personnel use too many of the same "Recipe" in a given time period. I have...

Hi all, I have been playing around with a function all day and it is driving me nuts. My goal is to automatically calculate the volatility of a warrant's (equity) price over time as it approaches the end of its term (in this case 60 months). I want to create a formula that takes the STDEV of...

Gday all, I've been trying my hand at writing a macro to compile data from two separate sheets, I've gotten a lot of more simple stuff to work but the macro i've created to copy selective rows of data into a new sheet seems to do nothing. I figure i've probably got some usage/ syntax way off...