indirect reference

Long story short, I have specific columns on the right side of my worksheet that will 'show' or 'hide' depending on input from the left side of the worksheet. If it was just me, I would do this manually and not bat an eye, but I give this worksheet to a bunch of people who think the only way to...

Hello all, I am working with a somewhat complicated formula that seems to work when referencing cell values with text, but not when cell values are numbers...

I'm struggling to make the following formula dynamic and be able to change the cells if references. I have this formula which works fine: =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets!$C$1:$AM$1&"'!A:A"),$A4,INDIRECT("'"&Sheets!$C$1:$AM$1&"'!"&C$1))) However in sheet 'Sheets' I may not always want...

I can't make indirect references in the camera tool! Lets say I name some ranges "triangle", "square" and "circle" and inside I put respective shapes. If I create a "camera window" (or wtv) and change it's formula to "=square" it will work. If I use the mouse to pick up or type the specific...

Hi, I'm new to the forum, usually I've been able to search and find solutions but this time I'm at a loss. I'm trying to select to the last cell with a value in a non-contiguous column without using a direct column reference. I'm using a downloaded report and sometimes upper management adds or...

​Hi all, First post. I do hope that I'm complying with the norms and terms and that my question is clear and not overly complicated. That out of the way... I'm clearly a beginner, using office 2010, tasked with (and so far failing miserably at) putting together some code for my new position. I...

Hello, I'm hoping someone can assist. I have run into another issue. I have a workbook that has several sheets. The sheets are created based on a named range. What I am trying to do is with the main worksheet ("Project Tracker"), I am trying to enter a formula in the Due by date. If the...

Hello! I'm having a spot of difficulty, and after time spent researching the issue on the web and forum I've come up with no answers. I have an INDIRECT function as follows: INDIRECT("Interface!R2C"&(Code!R[-1]C+1)&":R27C27") This resolves successfully to the following formula, as shown by...

Hello! I'm having a spot of difficulty, and after time spent researching the issue on the web and forum I've come up with no answers. I have an INDIRECT function as follows: INDIRECT("Interface!R2C"&(Code!R[-1]C+1)&":R27C27") This resolves successfully to the following formula, as shown by...

Hi all, Long time reader - first time poster. As the rather cryptic subject says, I'm trying to dynamically populate ranges to facilitate dynamic charts being generated. I use excel 2010 at work, and 2011 for mac at home. I have an example spreadsheet, but I don't know if I can upload it...

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 Thanks to the help I was able to built a code that retreives the worksheet name in column 5, now I was looking -but I din't find - a way to have the Indirect funtion to point the sheet name and in addition to retrieve the last cell with data in a specific column (that changes based on the...

Hi, I need to change the source for a pivot table based on the value in a cell. I have a worksheet named 'Summary' with a cell (A1) that has a dropdown containing the choices of Option1 and Option2 which refer to worksheets named 'Option1' and 'Option2' (this changes dynamically and there may...

Hello, I have a problem with declaring a variable which I want to use later in my macro. The problem is that I need to first "calculate" this variable which is dependent on the file name. I used "if then else" statement to pull out from the file name one thing that changes - week number. The...

First, I've read similar posts and tried the answers but they're not working in my workbook. Here is my formula; =VLOOKUP(TRIM(CONSOLIDATION[@[Host Name]]),INDIRECT("'[INSERT TRUE UP WORKBOOK NAME HERE]"&CONSOLIDATION[@[SITE-FE]]&"'!$B$9:$J$8361"),7,FALSE)) Instead of substituting the...

Hello everyone, Long time reader, first time poster here. I'm trying to do a piece of work that involves incremental drift for salaries and I'm having an issue I could use some help with. We have 12 pay bands running 1 - 7, 8a, 8b, 8c, 8d and 9. Each pay band has a number of salaries...

I have this formula for conditional formatting: =INDIRECT("G"&ROW())=3 This works perfectly fine, now i want change colour of cells if 2 different rows contain a certain number, so: Column G = 3 and Column K = 2 or 3 and the rows should be highlighted only if both columns match? Help?

I have created a summary worksheet that includes data from 10 separate worksheets in the same workbook. I am looking for help with creating a formula that will allow me to copy and paste(relative) from separate worksheets to the summary worksheet. For formula purposes, here are worksheets...

I have a list of values which are names of arrays Something like...