relative

I'm sure this is a common question but I have yet to be able to solve it even with searching the forums. The goal is to pull a date from the sheet 'Tracker' see if the date has passed or if it occurs within the next month. If true it needs to print an 'X' in the appropriate cell on the sheet...

Greetings, I'm trying to create a stacked bar chart, but with the length of the bar adjusted relative to a second series on the primary axis. I'm analyzing the occurance of key terms in the meetings of various departments, but I want the length of each department's bar proportional to the...

I have used range names for over 10 years However, I have a weird situation that I have not seen before and don’t seem to find on any postings anywhere on the internet. I define a range name and two odd situations occur: 1. when I reference that range name in a formula, it becomes a RELATIVE...

Hello All, I cannot find and information on this, maybe I am not searching it correctly, but I decided to make an account ask you smart folks. I have a large excel file that I am working on and have many hyperlink formulas added in (my links often break using the excel hyperlink function that...

Hi All! This is my second question in this great forum - thanks to CircledChicken, my first question was perfectly answered. This question should be easier I guess and it is again about referencing. I have the following table: <tbody> A B C D E 1 =average(B1:B3) 1 2 =average(C2:C4)...

Hi, Been a while since I was here but my memory is of a very knowledgeable forum so hopefully someone can help! I have a workbook in which I need to create a set of range names that effectively repeat 100 times. By way of explanation, say: Cells A1:A4 need to be called "Item_001_Header" Cells...

I have a macro with the following line of code Selection.AutoFill Destination:=Range("E2:E390") The problem is that the number of rows will not aways be the same. How do I change the code so that it finds the bottow rather than me telling it where the bottom is. Thanks in advance for any help.

Hi Guys, I'm making a template for a new set of reports that I'm producing and want to keep it fairly simple. I want a logo in the top right of the screen, as part of a header that I have already created that just consists of text in various cells. I can position the image absolutely, but I...

Hi Is there a way to copy cells that contain form controls so that the references become relative? I have removed the dollar-sign from the cell link field but that doesn't help. The new cells and form controls (spin buttons) get the same reference as the copied form control. Do I really have to...

Is there a formula, no VBA please, that can return the relative position of a worksheet in a workbook? For example, the formula would return a "2" when pointed at the second tab, and a 10 when pointed at the 10th? Thanks

The following code is the start of what I am trying to do. I want to always copy the entire row A155 and paste it to the active cell row (the cell that is currently selected when the macro is started). The problem however as soon as it selects the row to be copied my active row changes. I...

I have a sheet where I repeat the same formulas for different items every 41 lines. I have created graphs that fit within those lines and are based on the information gathered and calculated there. I tried to make the references for the graphs relative rather than absolute, but excel auto...

So simple, can't seem to find the answer I have a block of cells and I need to change all formulas from relative to absolute I've tried command-t, which doesn't do anything Also tried using the "Switch Reference" in the ribbon, which seems to work only when I am IN one cell. Any help would be...

howdy this code, which loads a KML file, is working great. I'm getting the coordinates of the current oCustomNode: Sub Add_Traverse_CustomXMLPart() Dim oCustomPart As CustomXMLPart Dim oCustomNode As CustomXMLNode Dim oCustomNodes As CustomXMLNodes 'Add a Custom XML Part...

Hi, So I have some code but I need to select a certain range to copy/paste into a different workbook. How can I have it copy a section above where it finds a specific value in a column? So I want to code to copy from A9:J9 and all the way down until 2 rows above the row where the word...

Is it possible to force a relative reference for the following: =INDIRECT("a"&1) I understand that this is an odd thing to try to do. What I'm trying to accomplish is too complicated for me to attempt to explain. Here is one of the formulas that I'm trying to force to be a relative...

Hello, Please refer to the following image as I describe my issue. First off, a description of what you see. This is a sercive sheet given to the service technicians of a ventilation company. They are supposed to follow the list of service objects according to the description (called...

My 'Update_Button' macro is supposed to do this - 1 - Open a file (Sample.xls) 2 - Update a button (Button 1) to point to a different macro 3 - Save the file 4 - Close the file More information - This macro is set to run on a directory and open each file and update each file. This macro is...

Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have this formula in VBA.<o:p></o:p> ActiveCell.FormulaR1C1 = _ "=COUNTBLANK('[Employee_Data_Report_TEST.xls]Missing Data'!R[1]C[1]:R" & NumRows & "C1)"<o:p></o:p> <o:p></o:p>...

Is there a way to write a formula to get it to read every Thursday in the past rolling? Something like an =today()-7 would work if it was Thursday, but how do I make it Thurday for today and have that same formula output Thursday still tomorrow? Does that make sense?