offset

Good day I need some help. I am trying to calculate the cumulative grades obtained by each of the students (5), in each of the subjects taken (9). For example if I select student Abby (D17) from a drop down list and I want to know her cumulative grade recorded in chemistry (D18), for cell D20 I...

Dear Friends, I am charting measurements from a CNC Machine with three axes, X, Y and Z. I created an Excel file that does exactly what it should…it charts the last three sets of 20 data points as expected. My issue is this…. I created a Word document to embed the three Excel Charts into...

Hi, Hoping this isn't a stupid question but here goes :) When I run the following code I want a change in column A (Target range) to trigger changes in columns C & D. When I add a value to column A, the Date will be inserted into column C and Username to column D. When I clear the value from...

Im a complete VBA noob and im trying to do what seems to be a simple thing. The purpose of my code is to make a button where it checks to see if the cell is not empty, it should offset to the next column and if it is empty, then it should add todays date. So each day I press the button it adds...

Hello, I have a table which includes statuses (red, yellow, green) which is based on two criterion: Stage and Days. The number of days for each of the statuses varies by the stage. I'm trying to find the easiest way to pull in the Status when I have the Stage and Days. I've included two...

Need help creating a combined list from values in two ranges. All non-blank items in list 1 should be included before adding the non-blank items in list 2. The headings between and after these lists should not be included in the resulting list. The challenge I'm having is that I don't know which...

I have weekly data. I would like to create a monthly indicator showing the % change from the last two weeks compared to the last two weeks for each month. The output should look as follows: A B 1 16M01 % (where this calculation is ((16W03+16W04)-(16W01+16W02)) /...

Hello, hope everything is good! I will try to be the most clear with the goal I'm tryin to achieve: I have a Sheet1 where I would like to enter a given record with some information about Country; Transit Type; Incoterm; Forwarder; Currency info. This would be almost what I needed (it...

I have this formula, if the first sheet is blank, then it will go to the second sheet first row with data and continue. It is similar to the vba pasting under that last row, however I don't want to use vba if I don't have to for this workbook. This hopefully is an easy fix to this problem. Any...

Hi, I'm looking for a way to change the Offset Top, Bottom, Left and Right values through VBA. The chart is an XY scatter plot. Any help appreciated!

Hi, I cannot figure out why Offset in VBA code gets stuck after running few times... The section of the code below is supposed to record a timer value from C2 in column G. First it checks if the first record exists in F3:G3. There's no value there yet, so it works: records the timer result...

I am trying to copy a picture using offset but I am not getting any data upon pasting. f.Offset(11, -8) is merged. I tested using f.Offset(11, -8).select on vba, then right-click copy, then paste to another sheet. I am getting the image, although not the right size. Here is my code: Sub...

Hi Guys, I have created a VBA code with help of a friend. The code copies contents of 2 columns on a sheet to a new sheet. But when I try to extend the code to copy more columns it just does not work. To be more clear it does not copy all of the cells below. Especially when I try to set it to 2...

I need to get the column next to my target value here is my data sheet Sheet1 Oct Nov Dec Points available Points Achieved % Achieved Points available Points Achieved % Achieved Points available Points Achieved 0 0 #VALUE! #VALUE! 0 0 0 0 0 0...

Hi everyone, I'm a little confused by some conditional formatting that I'm trying to do. I use the formula =OFFSET(Content!M3,MATCH(TODAY(),Content!I4:I58,0),0,1,1) on "sheet1" Cell "H64" - it simply matches today's date with dates in l4:l58 and then gives me the information from relevant...

Hi all, I have a macro that filters a table, then I am working on copying select pieces of data to another sheet. I have been able to copy individual cells, but I can't seem to copy an entire range, and any variation I make gives me errors. I'm sure its something very simple I'm doing wrong...

Hi everyone, Long time Excel user, first time posting as it has been some time since I have done anything with VBA and I have pretty much forgotten everything I once knew. I currently have a working macro that filters a list of copied data but because of some formatting issues in the source...

Hi I have Sheet1 that References Sheet2 as follows; Sheet1 in Cell A1, =Sheet2!A1 Sheet1 in Cell A2, =Sheet2!A2 Sheet1 In Cell B1, =Sheet2!B1 Sheet1 In Cell B2, =Sheet2!B2 Works Fine, but when the data on Sheet 2 for instance moves slightly ( as the data is an import ) it all goes wrong. I...

Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...

Hi All, First time poster, long time reader. I have been having an issue with a formula I am inputting into the data validation widget to create a dynamic dependant dropdown error. The formula is as follows: =OFFSET(Setup[[#Headers],[Savings]],1,MATCH([@[Expense...