referencing

Hi everyone, I have a lot of trouble with my cells references getting messed up after sorting. I have two columns (about 3000 rows) which look like : <tbody> 2 and 3 3 and 5 30 6 and 7 15 8 and 9 80 etc etc </tbody> Currently, the first columns are written like : cell A1...

Hi, got my code all set up but require a dynamic shell function when calling notepad. Currently it is as below (which works fine): Call Shell("notepad C:\Users\Shudarstaran.Neel\Desktop\DummyTest.xml", vbNormalFocus) I would like it to be dynamic and work like below...

Hey guys, here is my code: Option Explicit Public Sub TEST() Dim ProjectName As String Dim StartCellRow As Double, StartCellColumn As Double Dim Start As Range ProjectName = Sheets("Sheet1").Range("C1").Text Start = Sheets("Sheet2").Range("A").Find(ProjectName) StartCellRow =...

Hi everyone, I feel like this should not be so hard to figure out, but I am using excel 2013 and have this spreadsheet that is almost finished. The last part I need is referencing another file that changes dates everyday. 018_ArtikelInfo_20151215.csv That is an example of what the file is...

Hello! I'm normally pretty good a googling a solution for a VBA problem however this one has be stumped. Recently, our IT department transitioned one data cube over to another. In this new Data Cube our SKUs are now assigned a value. This value though is not shown in any accessible field. I...

Hi there! I'm a student intern trying to help out a colleague of mine by making his life with Excel a lot easier. Here is the schematic of what I'm trying to achieve: http://s27.postimg.org/861dvxjte/myexcelproblem.jpg note: P47 should be P37, it's a typo (further information explains the...

Hello, I'm having a problem referencing set variables and ranges in my formula: Selection.FormulaArray = _ "=AVERAGE(IF(MONTH(Data!C2:C2315)=11,Data!X2:X2315))" This works fine but I would like it to be dynamic as the data range and condition changes. I would like the '=11'...

I'm having some difficulty referencing my SUMIF formulas that have multiple criteria to an external workbook that contains multiple sheets. Currently I am able to link to an individual sheet with this: =SUM(IF(('X:\MAM\Tracking\Yearly Reports\[2014 Report.xlsm]Jan'!$D$7:$D$2000="Criteria...

Hi everyone, I've lurked here for a while and have found this forum very helpful but I haven't been able to find a solution to the question I have. I have used the search in both the forum and the advanced Google search on the main page. Into the problem... I have a file right now that...

I am creating a spreadsheet that references another spreadsheet of mine and I am trying to find out how to reference every 16th cell in a column to every row in another column. I have a form on one sheet where users can enter all of their information and I want to create a separate overview...

I have this code (below) that runs great on two of three PC's but the 3rd PC keeps getting a "compile error - project or library not found:". I've done a little research and most results came up referencing with VBIDE. Problem is I have no idea where or what that is yet. Can someone help me...

Thanks for your help. I have Column A which is an Employees birth Year, Column B which is salary, and Column C which is a list of Years. I need a formula to read the Year in Column C, refer to Column A finding all the rows that match that year, than refer to Column B (salaries) and find the...

I am trying to reference two cells and have both values show up in one cell. I would like for cell C1 to say 10:54:13 to 10:56:13. I attempted to write =A1 to =A3 inside cell C1 but I always get an error. What is the macro I need to write in order to make C1 show values of A1 and A3 with...

I have a vloopup calculation between two workbooks. The vlookup returns #ref! errors when the second workbook isn't open. You can get the references to work by opening the main workbook, then opening the sub workbook, clicking save. Next time you open it you have to click don't update links...

I want to find how to reference dates in months. For example, how can I create a formula in Cell E 43 and F 43, which will look up in the tables of debt drawdown "dates" and debt repayments "dates", and check if any of these happened to be in that particular "month", and if yes, the value...

I was wondering if there was a way for a cell that references a span could spawn at the first cell referenced rather than the last. example - cell A1 on sheet 1 references cells B1:B52 on sheet 2. When I click on A1, which is hyperlink, it takes me to B52 on sheet 2 rather than B1. Is there a...

BIG PICTURE: Create a script that at the touch of a button will consistently format and save each worksheet as its own .pdf. WHAT I HAVE SO FAR: I have a working VBA for the formatting and a working VBA for the "Save As... pdf", but I am stuck on how to properly do a VBA reference loop. I have...

Simple explanation - I want to reference a cell in a work sheet. Easy enough I just type =Sheet1!A1. The problem I have is that I will need to run a report every two weeks so the cell's column will change. For example in week 1 the column would be A so the above formula is fine. But in week2...

Hi Everyone. Ok so I need to know how do I reference a column in a formula, but NOT by its letter E, F, D etc. But by its text or number in Row 1. My formula I've got needs to find a column with a particular text in, then take all values related with that column. Now I know you will say why...

Hey Guys, Is there any way I can get excel to produce a column of all the values of a set cell from all sheets with a given characteristic? For example, if I wanted to form a column in my first worksheet comprising all the values of cell C3 from worksheets where A1 = education. Thanks very...