relative

I really don't understand why Excel is so complicated when you autofill down in picking the correct range. Even if I record a macro and use Relative cell references, it still hard codes a range into the command. I have a formula in cell P2 that I want autofill to the bottom of the table. I...

Hello I am kind of understand what is Relative and Absolute address but I would like a real life analogy that would help to understand the concept. Is there any example? Thank you.

Hi All, I have been trying to create a Macro to copy data from a hyperlinked excel sheet, but have not had much luck. Basically I have a master excel workbook with columns for different data. This data is populated manually from other excel workbooks which are of a standardised format and the...

Hi, How do you switch recording a macro from relative reference to absolute reference? Using Excel 2003. Thanks

Sub test() ' ' ' Record macro gives me this: ActiveCell.FormulaR1C1 = "='Sheet1'!R[-45]C[8]" ' I want the actual cell it is getting...like this...but this doesn't work. ActiveCell.Formula = "='Sheet1'!I3" ' This is what I want but it doesn't work ? End Sub

Hi I would like to do the following for a number of different columns: GP1 = F1 GQ1 = (GP1 - 1)*D1 Column GP is far removed from column F and therefore I re-display value. Column "F" is not constant, but column "D" will always be offset -2 relative to F. How can I do this without having to...

I have the following to set "shadow" to false but don't know how to do the same for the "relative to size" setting to true. Sub Comments_Format() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Shadow.Visible = msoFalse Next cmt End...

Dear all, Good day! I am trying to write vba code for copying a relative formula in a cell if formula in that cell is deleted by mistake. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("c14:c1014")) Is Nothing And Target.Count = 1 Then...

Hey, guys.:beerchug: So, obviously, I stumbled upon something that I can't seem to figure out myself. I googled, read and watched a lot. But this problem seems to be a bit too specific to find a solution on web. 80 items. Each item has a different "value" relative to each other. I want to put...

<tbody> My problem is this: I have a column of numbers that are not necessarily sequential and are not sorted numerically. Using a formula, I would like to return the relative number of those numbers in a new column. For example: I have a column of 4 numbers: 1, 1, 4, 2, 1, 1, 5...

Each month I update/change the file name and have had do manually go in and edit all macros. Is there a way to avoid this? Also, from what I've seen online, many recommend using "ActiveWookbook" or something similar....this will not work for me as I have macros pulling from multiple workbooks at...

I have a spreadsheet with many checkboxes and a checkbox determines if a row is going to be used in some calculations. Some sections have many rows, and to make it easier to select many row at once, I though it would be a great idea to add a "select all" checkbox. My spreadsheet was "macro...

I have never used conditional formatting before today. I have a list of assignments and due dates. I've applied conditional formatting to the due dates (column D) seen below The only problem is that it is showing red for assignments that are already complete (column F) and I need it to just...

I am using excel 2013 and a conditional formula based on a formula. The conditional formula is applied to cell A13 is: =OR(LEN(D13)>0,LEN(E13)>0,LEN(F13)>0) When these conditions are met, color the cell green otherwise leave it as is. Notice there are NO $ Dollar signs. However when I use the...

I'm trying to transpose a spreadsheet (information I need goes down the list in rows) into column headings of another spreadsheet. Should be fairly simple, but when I copy the formula into my column headings (="SHEET2'!$B2) and copy the formula over into the next column, it treats the $B2...

Hello, First I have to say I am pretty new to vba programming. Now I have that problem: I made several macros on an excel worksheet that use absolute values. Can I add for example 5 rows at the start of the sheet and update macro to change it's lines-values accordingly? There are too many...

So I'm new to coding and I was just wondering... Basically, I''ve created a code (for pivot tables) that auto refreshes and inputs the new field into the Values table relative to a cell that has a value (201428). ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _...

I have a whole bunch of cells that are like: A1 = sum(B1:Z1) A2 = sum (B2:Z2) ... A100 = sum (B100:Z100) I can figure out how to change just one cell (like A1) from relative to absolute (highlighting whole formula, then going to the Formulas toolbar and switching references button - so I can...

I'm going to be adding columns in a fairly complex worksheet and want to get rid of column labels inside INDIRECT so that the formulas will remain relative references as columns are added. I have this so far: SUM(INDIRECT("R" & ROW()-X$4+1):INDIRECT(cell("ADDRESS",R7)) The ending point for...

So have large spreadsheet with grid of elevations. Each column/row is 1 foot grid. There are blanks in it where there was no elevation data available. I need to interpolate those elevations using the surrounding known elevations. I can setup the interpolation just fine using a circular...