dynamic cell reference

Excel 2007 pivot table range problem. My source data range goes from dynamic to static. I've simplified the problem to just the core and here it is: Data is a 3x2 range in cells A1:B3. Reference to data range in cell E4. E4 contains text: A1:B3 I reference the range using the indirect...

Hello. I'm using Excel 2007. I'd like to create a sort-of ever-present, floating note that helps me navigate quickly through my alphabetically organized sheet. The most direct/quickest way I've found to navigate up & down a sheet is via the Name Box. What I'd like to have is a floating note (or...

Hi, I have what I thought was a simple problem but having googled at length I have been unable to find a simple solution and am grateful for any help anyone can offer. Each member of staff has a work book and in the work book are work sheets with the names of the months of the year. I can not...

hi all, I am working on a project which I wrote repeatedly "Sheets(x).Cells(i,n)" and "Sheets(y).Cells(j,m)" where x, y, n and m are constants, while i and j are loop variables. After a while, I am lost on which is which. Hereby I want to create two variables, preferably named "targetCell"...

Hello guys, I'm having difficulties with this piece of code. I have searched the forum, but no luck till now (maybe im not using the right keywords).Here is my problem and thanks in advance. I am trying to create a chart with VBA that compares the metric (grade percentage) of different people...

Hello, Every week I receive a report (always 16 columns, same file name, new rows added every week) that I analyse using a pivot table, using the same filtering set up every week. In Excel 2010, I want to build a "Master Pivot" that will refresh automatically with the new data.To do so I have...

Hi all, I have tried numerous ways to approach this problem to no avail but maybe someone can finally help me solve it. I have to pull dates from excel spreadsheets that are stored online. There are around 50 different spreadsheets that I need to get the same data from. Each spreadsheet has the...

Hi Hopefully someone can help here as I have drawn a complete blank! I have a table with dates as headers. I want to sumif rows where the sum_range is dynamically referenced. So this formula works... =SUMIF(Rev_WK12[[#All],[ITEM]],A8,Rev_WK12[[#All],[30/03/2013]]) table name = Rev_WK12 A8...

I am trying to populate a second combobox in a userform using the values of the previous combo box using Excel 2010. The first combobox is populated using properties - rowsource - List1Values (I defined dynamic names in the Data spreadsheet). I am attempting to use the following code to populate...

Hi, I have a very simple spreadsheet that shows in worksheet 1 a table of scoring, which I may need to sort by score, salary band or both so these cells are dynamic. eg <TBODY> Name Salary Band Total Score Vic A 14 Jo B 6 Bob c 16 </TBODY> In worksheet 2 I have a static table set out...